Ok this is a known bug from Oracle. It is fixed for 9.2 version.
Is there a sibling patch for 8.1.7 ? Thanks again.
"Xela" <abuse_at_yahoo.com> wrote in message
news:ctnk20$haj$1_at_reader1.imaginet.fr...
> 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:54:20 CST
