Interval Partitioning with Local Index - How to refer to Index Partition for specific key?
I need to reorganise a table which is Interval partitioned and has a number of local indexes. The partitioning is on a monthly interval and I need to move table and index partitions to year-specific tablespaces.
I can easily identify the partition names for the table partitions (..PARTITION FOR..) for a given key - eg:
ALTER TABLE BI_EDW.WC_CASH_F MOVE PARTITION FOR(DATE'2014-06-01') TABLESPACE EDW_WC_CSH_F_D14;
This works fine.
However, when I try something equivalent for the local index partitions:
ALTER INDEX BI_EDW.WC_CASH_F_X05 REBUILD PARTITION FOR (DATE'2014-06-01') TABLESPACE EDW_WC_CSH_F_I14;