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

3 votes302 views1 answer
Mysql cli connect with password
SQL
0 vote241 views1 answer
Postgres type equivalent to timespan c#
SQL
6 votes255 views2 answers
Mysqldump password in file
SQL
3 votes249 views2 answers
Oracle privileges users
SQL
3 votes262 views3 answers
Update con select postgresql
SQL
0 vote224 views1 answer
Add column in sql server ubuntu
SQL
0 vote231 views1 answer
Drop constraint in ms sql
SQL
0 vote234 views1 answer
Mariadb used space
SQL
0 vote223 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
1 vote240 views1 answer
Query for all indexes in table postgres
SQL