Adding partitions 11g/12c Dropping partition 11g/12c Truncate partitions Merge partition Make a partition ready only (12CR2) Split partition online (12cR2 only) Non-partition to partition Rename a partition Get row_count of partitions of a table Find the table partition keys Move partition to new tablespace
Useful views to get index details: dba_indexes dba_segments dba_ind_columns dba_ind_partitions user_indexes user_segments user_ind_columns user_ind_partitions Query to check Index on a Table in Oracle. Find the list of top index size corresponding to a table. Check Index Column on a Table in Oracle. Find total index size of respective tables in a schema. Find the list … Read more