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 vote380 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
0 vote329 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
0 vote288 views1 answer
SQL get max per id
SQL
10 votes277 views1 answer
Oracle dependency
SQL
1 vote302 views1 answer
Full sql mode
SQL
0 vote318 views3 answers
How to run sql query
SQL
0 vote314 views1 answer
Start stop mysql linux
SQL
2 votes309 views1 answer
Postgresql change value in column
SQL
0 vote301 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
4 votes305 views3 answers
Order by value mysql
SQL