Partition exchange ORA-02266

Hello,

I have a problem. I try do do a partition exchange from an empty non partitionned table with a non empty partition of a partitionned table. I have this message :
ORA-02266: unique/primary keys in table referenced by enabled foreign keys I understand the meaning of this message but, I can't find any enabled foreign key related to the exchanged table : the request

select constraint_name, table_name, status from user_constraints
where r_constraint_name in (
select constraint_name from user_constraints where table_name ='tabnam');

returns only disabled foreign keys. However, I am able to truncate the partition of the partitionned table and I can the proceed to the exchange. But this process is not useful.
I use Oracle 9.2.0.1.0 on Windows XP pro. Any clue?

Many thanks for your attention.

    Alexandre Received on Tue Feb 01 2005 - 04:25:03 CST