No question at this time
DBA Top 10
1 M. Cadot 6600
2 B. Vroman 3400
3 J. PĂ©ran 2200
4 A. Kavsek 1400
5 P. Tsongayinwe 900
6 P. Wisse 600
7 T. Boles 400
7 D. Walgude 400
7 D. Johnson 400
10 J. Alcroft 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48675
Total active users1328
Act. users last 24h0
Act. users last hour0
Registered user hits last week24
Registered user hits last month452
Go up

Skipping "Enable Constraints" in import
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...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts 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, 5711 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, 5711 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
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