ORA-14128: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE PARTITION
We are getting the below error while exchanging the partition ( where it was working fine since 1999 and there is no changes in the table level )
> alter table retek.item_sales_hist exchange partition ITEM_SALES_HIST_20101030 with table retek.item_sales_hist_exch including indexes with validation
*
ERROR at line 1:
ORA-14128: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE PARTITION
Here the retek.item_sales_hist_exch table --------------------> there is no records (Zero)
select count(*) from retek.item_sales_hist_exch;
COUNT(*)
----------
0
Note : I have tried to disable the FOREIGN KEY constraint and it is working fine but customer wants the RCA