|
|
Ispirer SQLWays Database Migration Software
DROP TABLE Errors, ORA-02449: unique/primary keys in table referenced by foreign keys
When SQLWays executes the DROP TABLE statements before creating tables, Oracle may return the error ORA-02449. This means that the table cannot be dropped because it is referenced by a FOREIGN KEY constraint.
To drop tables referenced by child tables, you can the CASCADE CONSTRAINTS option in the DROP TABLE statement. For more information, see Dropping Tables.
To generate the CASCADE CONSTRAINTS option for Oracle
|
|