Database Utilities (MOSC)

MOSC Banner

I have impdp jobs in Oracle 12c that take a looooong time to import the index/index objects.

edited Apr 26, 2017 2:48PM in Database Utilities (MOSC) 6 commentsAnswered ✓

Case in point.  In an impdp job the entire job had an elapsed time of  01:25:59

but the step Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX step

     Completed 3388 INDEX objects in 4179 seconds which is 1:09:39.

Here is the impdp command

impdp user/password directory=ext_dp dumpfile=gr.dmp logfile=gr-imp.log

job_name=gr schemas=grprod REMAP_SCHEMA=grprod:grdebug table_exists_action=replace

version=12.1.0 transform=oid:n metrics=Y

Both the source SID and the Destination SID are Oracle12c, stand alone, enterprise edition instances

Are there any tuning parameters in Oracle or in the IMPDP command?

Thank  you.

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