Import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Import

  1. #1
    Join Date
    Sep 2000
    Posts
    33
    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!

  2. #2
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    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

  3. #3
    Join Date
    Sep 2000
    Posts
    33
    I have tried large buffer size but the speed does not improve. I have 1 GB Ram.

  4. #4
    Join Date
    Apr 2001
    Location
    hyderabad,india
    Posts
    27
    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]

  5. #5
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227
    I agree. Try direct import.
    leonard905
    leonard905@yahoo.com

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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
  •  


Click Here to Expand Forum to Full Width