Go up

Next thread:	Require Patch "4198954"
Prev thread:	afiedt.buf

Message	Score	Author	Date
Hi All During the import, once the rows are imp......		G Balaji	Nov 12, 2006, 19:19
Hi Balaji, cmd> imp fromuser=... touser=... con......		Ales Kavsek	Nov 12, 2006, 20:40

Follow up by mail

Click here

---

Subject:	Skipping "Enable Constraints" in import
Author:	G Balaji, India
Date:	Nov 12, 2006, 19:19, 6046 days ago
Os info:	HP-UX
Oracle info:	9.2.0.6
Message:	Hi All During the import, once the rows are imported, oracle will automatically enable the constraints. Is there any way we can by-pass this phase? I disabled the constraints before the import and want to enable it with NOVALIDATE so that it will reduce my import time. Any suggestions? Thanks Balaji
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: Skipping "Enable Constraints" in import
Author:	Ales Kavsek, Slovenia
Date:	Nov 12, 2006, 20:40, 6046 days ago
Score:
Message:	Hi Balaji, cmd> imp fromuser=... touser=... constraints=n ignore=y If you have empty target schema, then: 1) export with rows=n and import this dump into target schema 2) disable constraints with sql script 3) during import of the dump file (with rows) specify constraints=n ignore=y 4) enable constraints with sql script Note, that you'll still get message "About to enable constraints..." in the import log but constraints will not be enabled. Regards, Ales
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here