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

5 votes360 views1 answer
Oracle nls instance
SQL
1 vote344 views1 answer
Import database from a file using mysql commandline
SQL
0 vote379 views1 answer
Oracle exchange subpartition
SQL
0 vote390 views1 answer
Mysql get first 2 characters of string
SQL
0 vote309 views1 answer
Big query add table rows to another table
SQL
0 vote382 views1 answer
Netstat -tln mysql
SQL
1 vote376 views1 answer
Database Queries
SQL
2 votes351 views1 answer
How to show the whole table in sql
SQL
2 votes396 views1 answer
Oracle find constraints referencing a table
SQL
1 vote332 views1 answer
T-SQL Alter the column data type
SQL