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

8 votes131 views1 answer
Sql limit results returned
SQL
10 votes126 views4 answers
Sql pagination
SQL
24 votes124 views2 answers
Alter table delete column
SQL
1 vote140 views1 answer
Sql week commencing date
SQL
6 votes137 views2 answers
Postgresql restore from dump
SQL
4 votes168 views6 answers
Select sql
SQL
0 vote143 views1 answer
Sql combine results from two tables
SQL
0 vote135 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote124 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote128 views2 answers
Postgres default user
SQL