Database DataWarehousing (MOSC)

MOSC Banner

Exchange Partition - Help needed urgent

edited Jan 14, 2010 12:58AM in Database DataWarehousing (MOSC) 4 commentsAnswered
Hi All, I encountered the following error

ORA-14130: UNIQUE CONSTRAINTS mismatch IN ALTER TABLE EXCHANGE PARTITION

while executing exchange partition command

ALTER TABLE RCM EXCHANGE PARTITION PART_20052009 WITH TABLE RCM_TEMP EXCLUDING INDEXES WITHOUT VALIDATION

Main table has : two non unique local indexes, and one unique(pk) index
temporary table  : has No indexes.

This exchange is working fine in two databases(one 10.2.0.4 and another 9.2.0.8) but not working in another database (9.2.0.8). I have found this in my testing environment. There are no object level change done to these tables. Thank god it is not yet bombed in Production. But could some body help me to identify the problem??? Why is it working in one db and not in other?

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