Oracle index partition

SELECT INDEX_NAME,
       PARTITION_NAME,
       TABLESPACE_NAME,
       INITIAL_EXTENT,
       NEXT_EXTENT,
       PCT_INCREASE,
       NUM_ROWS
FROM DBA_IND_PARTITIONS
WHERE INDEX_NAME = decode(upper('my_index'), 'ALL', INDEX_NAME, upper('my_index'))
  AND INDEX_OWNER = upper('my_owner')
ORDER BY INDEX_NAME, PARTITION_NAME;

Similar codes

0 vote117 views1 answer
Create database store
SQL
0 vote111 views1 answer
Oracle procedure chain step
SQL
3 votes113 views1 answer
Export postgres database linux
SQL
20 votes144 views4 answers
How to find average in sql
SQL
0 vote122 views1 answer
Database db connection string format
SQL
0 vote140 views1 answer
TSQL Find csv file in folder
SQL
1 vote111 views1 answer
Media sql
SQL
0 vote121 views1 answer
How to add more columns to a table in mysql
SQL
1 vote128 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote121 views1 answer
Teller stamp , bmo , PDF
SQL