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

Thread: faster import of db objects

  1. #1
    Join Date
    Mar 2008
    Posts
    140

    faster import of db objects

    Hi, how can we speed up the importing object to database using imp utility.


    thanks,

  2. #2
    Join Date
    Dec 2001
    Posts
    320
    Have a look at Buffer parameter here

    You may also consider splitting up the job into pieces so do multiple imports in parallel instead of one import sequentially.
    Anyone can hold the helm when the sea is calm.

  3. #3
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    imp will not support parallel parameter. You need to write a explicit program to do imports in parallel sessions if you have multiple dump files.

    You can create the indexfile from the dump file and import with out indexes then create the indexes manually.

    by the way, what is the Oracle version?

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  4. #4
    Join Date
    Dec 2001
    Posts
    320
    Quote Originally Posted by vnktummala View Post
    imp will not support parallel parameter. You need to write a explicit program to do imports in parallel sessions if you have multiple dump files.

    Thanks,
    I wasn't actually refering to a "parallel" parameter. As mentioned split the import job into more than one job, i.e more than one import session, a session importing some of the tables, another importing the others and so on.
    Anyone can hold the helm when the sea is calm.

  5. #5
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    I understand what you mean to say Hany. I just want to make the poster more clear about doing imp in multiple sessions.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  6. #6
    Join Date
    Mar 2010
    Posts
    7
    you can create an indexfile so that you can create indexes AFTER you have imported data. Do this by setting INDEXFILE to a filename and then import. No data will be imported but a file containing index definitions will be created. You must edit this file afterwards and supply the passwords for the schemas on all CONNECT statements

  7. #7
    Join Date
    Mar 2010
    Posts
    7
    or u can increase the db_cache_size and set the log_buffer to a high value

  8. #8
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    Quote Originally Posted by naman20k View Post
    or u can increase the db_cache_size and set the log_buffer to a high value
    How will that increase the import speed?
    lucky

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