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

23 votes364 views4 answers
Sql server substring
SQL
0 vote367 views1 answer
Mysql c commands
SQL
0 vote354 views1 answer
Duplicate value unique constraint mysql error
SQL
1 vote341 views1 answer
Mysql column start with string
SQL
9 votes370 views2 answers
Cmd to rename a collumn name in sql
SQL
3 votes399 views1 answer
Laravel paginate raw sql
SQL
0 vote361 views1 answer
Mysql table variables
SQL
1 vote366 views1 answer
Sql select contem uma palavra
SQL
1 vote405 views1 answer
Sql server read uncommitted
SQL
13 votes358 views2 answers
Sql join
SQL