Re: constraints during migration

Posted by ErmanArslansOracleBlog on Jun 24, 2019; 1:15pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/constraints-during-migration-tp7445p7449.html

Read this-> https://docs.oracle.com/database/121/SUTIL/GUID-47D52BE2-72CD-47E7-B4EE-462F5AF4ABA0.htm
 
Ref :Oracle

Manually Ordering the Import
When the constraints are reenabled after importing, the entire table is checked, which may take a long time for a large table. If the time required for that check is too long, then it may be beneficial to order the import manually.

To do so, perform several imports from an export file instead of one. First, import tables that are the targets of referential checks. Then, import the tables that reference them. This option works if tables do not reference each other in a circular fashion, and if a table does not reference itself.