Hi,
when i tried to do exchange partition from table a to table b both has same foreign key constraint on same column referrring to table c.
here table a is range partition month wise and b is not partitioned table.
Both does not have data violating foreign key constraint.
<<code>>
alter table a
exchange partition a_20101002
with table b
including indexes with validation;
when above statement is executed the following ora-14128 is thrown.
i made table b foreign key as enable no validate and this statement is executed with no problems,can i know why suddenly i got this error since ever month i will be doing this activity and no error thrown suddenly today i got this error.
how to get this overcome without altering foreign key of table b