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 votes279 views1 answer
Oracle ORA-00054 origin
SQL
3 votes258 views1 answer
V$session not found in oracle
SQL
4 votes287 views1 answer
Conda install sqlalchemy
SQL
0 vote257 views1 answer
Sql comparison operators
SQL
-1 vote248 views1 answer
How to format tables in sqlplus
SQL
1 vote265 views1 answer
Postgresql filter on
SQL
3 votes269 views1 answer
Oracle apex warning message
SQL
0 vote314 views1 answer
Dockerfile example for Django
SQL
0 vote389 views1 answer
ORA-01400
SQL
0 vote279 views1 answer
Create database store
SQL