Database DataWarehousing (MOSC)

MOSC Banner

HOW CAN WE PARTITION A PK INDEX ?

edited Jul 27, 2011 1:53AM in Database DataWarehousing (MOSC) 5 commentsAnswered
   We have a partitioned table by range (timestamp data), with a PK by id with a no partitioned index.

We are trying to generate a partitioned PK index, allowing PK index partition as a local index.

In order to do so, we test PK recreation by (id, timestamp) but the PK index is still unpartitioned.

Any idea about how can we solve the issue?

Thanks in advance for your help!

 

Luis.

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