Hi,


created a partition table with Global Partition indexing. I dropped a partition and created new partition without any index creations. The drop partition still left the partition index and didn't create a new index for the new added partition.

SQL> SELECT INDEX_NAME, PARTITION_NAME, STATUS FROM USER_IND_PARTITIONS;


INDEX_NAME PARTITION_NAME STATUS
------------------------------ ------------------------------ --------
PTTRACKLOG_PAR_INDX PT1 UNUSABLE
PTTRACKLOG_PAR_INDX PT3 USABLE
PTTRACKLOG_PAR_INDX PT2 USABLE


SQL> select table_name, partition_name from user_tab_partitions;

TABLE_NAME PARTITION_NAME
------------------------------ ------------------------------
ASH_PTTRACKLOG PT4
ASH_PTTRACKLOG PT3
ASH_PTTRACKLOG PT2

From the above - PT1 partition is dropped and PT4 is added. PT1 index is still existing but unusable and PT4 partition didn't create any new index on PT4?
If i drop a partition, should this also drop the corresponding partition index if the Global indexing is using?

If a new parition is added, will this create a new partition index automatically, with the same name as new tabl partition?

Should all the partition indexes needs to be rebulit or just the index on the new partition added?


Thanks.