1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

improve oracle dump importing

Discussion in 'SQL PL/SQL' started by khotsuhas, May 19, 2010.

  1. khotsuhas

    khotsuhas Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    I am importing oracle dump on server using impdp command. And my dump size is about 200MB.
    Its takes around 4 hrs to import dump.
    I tried with excluding statistics. Using this I can import dump in 3 hrs.

    Please help me out to import dump in half an hour.
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Import performance depends on lot of things like server performance, DB activities , Database params etc.

    Anyway , Try to import as per the following link.

    Import performance

    Import5 performance
     
    khotsuhas likes this.