disable constraints before export to improve performance of import?
Hi guys.
I'm now importing a single user into a different database. The problem is that it takes a long time and I get the feeling it's because of the constraints. I import all tables in a new user schema, so all tables are created and the data is freshly inserted. I guess the constraints are checked at every new inserted row.
Because the referential integrity was okay in the original database, I guess the validation during the import is obsolete in this case?
Is there a way to import the data in such a way, that the check on the constraints is postponed. The import could go faster and I could enable the constraints at night...
The procedure/issued commands :
- drop all tables from user APP01;
- drop all other objects from user APP01;
- imp system/manager@db01 FULL=N FROMUSER=APP01 TOUSER=APP01 IGNORE=Y file=c:\oracle\oradata\db01\import\db02_full.dmp
Hmmm now checking the help-info again... can I use TOID_NOVALIDATE for this?
Thanks in advance and have a good weekend!