Results 1 to 5 of 5
  1. #1
    Join Date
    May 2012
    Posts
    2

    Unanswered: Oracle IMP running so slow

    Hello!

    We are currently migrating Oracle 10g database from an IBM P5 machine with AIX 5.3 OS to an IBM P730 machine with AIX 6.1. We are already in the process of importing the data to the new machine but the IMP was so slow, unlike the EXP process that only took less than 3 hours.

    As of now, we still can't import our data.

    Anybody here who can help us to resolve this?


    Thanks so much!

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    imp is deprecated, use expdb and impdb instead. They are much faster

  3. #3
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    IMP is always slower than EXP, because only the CREATE INDEX statements are exported, but during import the Indexes have to be built.

    So, depending on how many indexes you have on your system import can last significantly longer than the export.
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Also it always takes twice as long to write a row as to read it. Have patience.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  5. #5
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    A couple of things people often forget with imp is to specify a buffer and if it is a full database import you can put the database into no archivelog mode so no archivelogs are created (do a backup straight after though).

    Alan

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •