Import Defer Referential Contraint Checks

[rshivagami]

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 ?

[slimdave]

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?

[davey23uk]

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

[rshivagami]

Looks like that is what I have to do.