index problem

[Arsalan]

Hi sir

i exported schema from DB1 and importing to DB2, so while importing it take more time
almost 10 hours,, i check it creating indexes.

what is the solution this is my script.


impdp system/aone@dwh directory=backup schemas=sigtasad dumpfile=SIGTAS1.DMP logfile=imp_sigtas333.log remape_schemas=sigtasad:sigtasad PARALLEL=5 EXCLUD=USER



Regard

[ErmanArslansOracleBlog]

Hi,

check this note:

In What Order Are Indexes Built During Datapump Import (IMPDP) and How to Optimize the Index Creation (Doc ID 1966442.1)