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

2 votes303 views5 answers
Unique in sql server
SQL
0 vote152 views2 answers
Postgresql gset
SQL
0 vote141 views1 answer
Oracle free up space in tablespace
SQL
0 vote150 views1 answer
Version and edition of SQL Server Database Engine
SQL
1 vote143 views1 answer
Oracle split string
SQL
7 votes145 views4 answers
Lowest salary in sql
SQL
1 vote165 views1 answer
Oracle insert multiple rows into same table
SQL
3 votes168 views3 answers
1396(hy00) mysql error
SQL
0 vote148 views1 answer
Sql developer search all packages for text
SQL
9 votes203 views6 answers
Replace sql
SQL