Hi.
I was trying to truncate a table, which is a parent
to two other tables (its PK is referred to by two
FKs
from two other tables). These other tables are
empty.
When I tried to truncate the parent table, however,
I
got an error message ORA-02266: unique/primary keys
in
table referenced by
Hi Gene,
You cannot truncate a table that is a parent in enabled FK constraints.
You did the right thing. or you can simply delete (of course longer) with
enabled constraints.
--
Alexandre
Hi.
I was trying to truncate a table, which is a parent
to two other tables (its PK is referred to by
You did it right.
It's just the way oracle works.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 18, 2002 9:43 AM
Hi.
I was trying to truncate a table, which is a parent
to two other