Database Utilities (MOSC)

MOSC Banner

IMPDP enhancement

edited Jun 16, 2011 3:04AM in Database Utilities (MOSC) 1 commentAnswered
I am using Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit

i am tring to import dump file using data pump , file size : 80G

usually i use the below command

impdp dumpfile=dump.dmp logfile=logfile.log schemas=pro remap_schema=pro:test remap_tablespace=prodata:testdata remap_tablespace=proindex:testindex exclude=table_statistics

then i run gather stats to execute the statistics for schema test.

but this command take long time specialy whiling importing indexes (more than 8 hours)

so i did some researches to enhance the performance. such as :

1. do impdp with nologging :

can anyone show me the way to apply this?

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