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 ot
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
>
>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