Oracle 12c New Features

Oracle 12c New Features When you truncate a parent table with child tables, you get:ORA-02266: unique/primary keys in table referenced by enabled foreign keys. In Oracle 12c, you can use: truncate table <Parent> cascade; Must have defined the FK as ON DELETE CASCADE. Otherwise ORA-14705: unique or primary keys referenced by enabled foreign keys in… Continue reading Oracle 12c New Features