-
Hi All,
I am importing a schema into my DB. No data included. However my import is taking very long. Each table has an average of 50 columns. I have around 2000 tables. The dump file is a mere 50 MB. Yet the import is taking 6 hours to run. I used this command
imp retail/somo@somo.world file=/usr2/flexcube/somo/data/29MarSchemaRetail.dmp full=Y buffer=8192 commit=Y ignore=Y log=/usr2/flexcube/somo/data/23Apr2001.log
Is there any way I can speed up the import. At this rate it will take two days to import the data!
-
Buffer Size -Lock contention
Hi, 23rd April 2001 13:25 hrs chennai
Increase the buffer size to the maximum .
Look for lock contention.
Cheers
Padmam
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
-
I have tried large buffer size but the speed does not improve. I have 1 GB Ram.
-
hai,
use direct method of importing and disable indexes by indexes=n after importing recreate the indexes on respective tables
try with it
cheers
raghava rao
[Edited by yejurvad on 04-23-2001 at 06:10 AM]
-
I agree. Try direct import.
leonard905
leonard905@yahoo.com
-
Originally posted by leonard905
I agree. Try direct import.
Would someone care to explain how to do "direct import"?
This suggestion keeps poping up in this forum, yet there is no such thing as "direct import"!
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|