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 vote89 views1 answer
CREATE MULTIPLE FK
SQL
0 vote109 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote113 views1 answer
Learnxinyminutes sql
SQL
0 vote231 views1 answer
Oracle convert int to date
SQL
0 vote56 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
0 vote105 views1 answer
Oracle allow space to user
SQL
0 vote98 views1 answer
Order by monthly in sql
SQL
22 votes113 views3 answers
Remove all records from table mysql
SQL
1 vote107 views1 answer
OstgreSQL version
SQL
1 vote121 views1 answer
Get parameter value in mysql trigger
SQL