Database Utilities (MOSC)

MOSC Banner

impdp is very slow when importing indexes

in Database Utilities (MOSC) 9 commentsAnswered ✓

When doing import using impdp the process becomes very slow when it is importing indexes

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX


How we do the impdp:

cat > $PAR_FILE <<EOF

userid="sys/password as sysdba"

directory=dp_dir

dumpfile=dump.dp

logfile=dump.log

schemas=xxx,xxx

exclude=STATISTICS

trace=480300

EOF

 impdp parfile=$PAR_FILE


Background:

We have been performing the import from a source database (1) to destination database (1) for a long time. The dump.dp is around 100GB and it takes 5 hours for the import to finish. This is acceptable to us.

We have built another destination database (2) which is same as destination database (1) in terms of hardware and software requirements. However for the same dump.dp which is around 100GB it takes 15 hours for destination database (2) to finish the import.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center