Database Administration (MOSC)

MOSC Banner

ORA-14128: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE PARTITION

edited Dec 4, 2013 2:00AM in Database Administration (MOSC) 6 commentsAnswered
Hi ,

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

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