Database Administration (MOSC)

MOSC Banner

impdp taking 11 hours to complete for 90GB database

impdp taking 11 hours to complete for 90GB database

Database: oracle19.3.0.0

database size 90GB

OS: windows server 2012 R2

i am using impdp to build a clone of production database with new name.

when check with query it shows 99.99% completion and

take more than 10 hours at

Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER

following command is used in impdp

impdp 'sys/password@sid as sysdba' dir=data_pump_dir dumpfile=abc.dmp logfile=abc.log exclude=statistics exclude=packages table_exists_action=replace

Please suggest the solution for speeding up the impdp process.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center