By Kevin Shidler – This tip truncates data from tables using PL/SQL for Oracle8i. It first disables all foreign key constraints that would cause the “ORA-02266: unique/primary keys in table referenced by enabled foreign keys” error, truncates the tables, and then re-enables all the foreign keys.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help