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 vote346 views1 answer
Display first three characters sql
SQL
1 vote353 views1 answer
How to between in sql
SQL
0 vote354 views1 answer
How get data from database if id not found then search another column
SQL
0 vote334 views2 answers
Php convert dbf to mysql
SQL
0 vote317 views1 answer
Mysql earlier than date
SQL
3 votes356 views3 answers
Remove all spaces from string sql
SQL
16 votes342 views3 answers
Order by sql query
SQL
2 votes352 views1 answer
Oracle list grants on package
SQL
0 vote374 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
1 vote303 views1 answer
Restart identity postgresql
SQL