Database Utilities (MOSC)

MOSC Banner

Schema dump export taking too long

edited Nov 7, 2011 3:02AM in Database Utilities (MOSC) 5 commentsAnswered
Hallo!I am doing a schema export of a 110 GB schema.My backup script is as below

export DATE=$(date +%Y-%m-%d-%H-%M)expdp dumpfile=CBKLPROD_${DATE}.dmp logfile=CBKLPRODEXP_${DATE}.log directory=oradump5 schemas=CBKLPROD.The backup has been running for almost 3 hours and it has been stuck at the pointProcessing object type SCHEMA_EXPORT/JOBfor 2 and a half hours.I it normal for this to happen.I used the same script to backup the schema when it was 80 GB and the schema export took 1 hour.I am sure that the export is still running as the dump file is increasing and the Datapump job is showing EXECUTING when I do SELECT * FROM DBA_DATAPUMP_JOBS;

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