Table of ContentsPreviousNext

Ispirer
Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.
You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.
Check out the relevant toolkit documentation.
Ispirer Oracle Database Conversion overview.

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

Table of ContentsPreviousNext
Copyright 1999-2023 Ispirer Systems.
Ispirer and SQLWays are registered trademarks. All other product names may be trademarks of the respective companies.
All rights reserved.