-
Import Defer Referential Contraint Checks
I need to import some data into already existing tables. As the import normally happens in the alphabetical order of the table names, I am getting referential constraint errors during the import process. I can disable the referential constraints before import and then enable them once the import is complete, but that could take a while as this is a big DB. Any other way to acheive this ?
-
Ese separate import files that let you guarantee the import order? Run the import multiple times, specifying different tables each time to guarantee the import order?
-
lists the tables in the order you want in the TABLES= parameter of imp
diable constraints wont take too much time though, and if you are sure of the data enable them with novalidate etc
-
Looks like that is what I have to do.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|