Database DataWarehousing (MOSC)

MOSC Banner

Interval Partitioning with Local Index - How to refer to Index Partition for specific key?

edited Jun 24, 2014 10:59AM in Database DataWarehousing (MOSC) 4 commentsAnswered

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;
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center