enrique_aeo
asked on
PL/SQL: ORA-02266 with truncate, but with DELETE; it is OK... why?
Hi experts:
i have this error
02266, 00000, "unique/primary keys in table referenced by enabled foreign keys"
when try: TRUNCATE TABLE ta_cuenta_contable;
i solution with
DELETE FROM ta_cuenta_contable;
COMMIT;
why?
i have this error
02266, 00000, "unique/primary keys in table referenced by enabled foreign keys"
when try: TRUNCATE TABLE ta_cuenta_contable;
i solution with
DELETE FROM ta_cuenta_contable;
COMMIT;
why?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.