Database DataWarehousing (MOSC)

MOSC Banner

ORA-14402 and global partitioned index

edited Jan 14, 2010 12:43AM in Database DataWarehousing (MOSC) 3 commentsAnswered
 Does the row_movement concept apply to global partitioned indexes which has different partitioning column than the partitioned based table?
In other words, will oracle throw an ORA-14402 if the index (hash) partitioning column is updated that will caused it to hash to a different partition while the table row remains in tact in its current partition?

If yes, I don't see any move_enable syntax for the create index DDL.

There seems to be a lack of Oracle documentation on this.  Yes, I know, performing a simple test will provide the answer, but I am thinking someone has probably gone thru this already and I can save a little bit of time.   Thanks in advance for any feedbacks or responses

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