Stuck with ORA-02266...even through I've already disabled the FK constraints...?
cayenneDec 1 2009 — edited Dec 1 2009I'm working to help some people on a structure I really don't know much about...they're trying to truncate the table.
When trying to truncate table1:
I got the ORA-02266: unique/primary keys in table referenced by enabled foreign keys error,
I went through and have disabled every FK on the table....so, I'm a bit puzzled why I keep getting the same error.
I was thinking of disabling the PK...to see if for some reason that was holding things back (so far out of a bunch of tables, this is the ONLY table not responding to having all FK's disabled).
However, when I try to disable the PK I get:
ORA-02297: cannot disable constraint (owner.table1_pk) - dependencies exist
I've been looking around, and was going to maybe try the disable constraint with the cascade option, but, I'm not familiar with the cascade in this context...what will this do?
Will it cause any problems with this or other tables when I try to re-enable the PK constraint on table1?
Thank you in advance,
cayenne