Exchange Partition - Help needed urgent
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?
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?
0