Printable View
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.