No question at this time
DBA Top 10
1 M. Cadot 6300
2 B. Vroman 2700
3 P. Tsongayinwe 1500
4 P. Wisse 1300
4 J. PĂ©ran 1300
6 A. Kavsek 900
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 L. Ywema 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48709
Total active users1322
Act. users last 24h2
Act. users last hour0
Registered user hits last week33
Registered user hits last month217
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, 5859 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, 5859 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