Oracle 23c New Features for DBA's
My friend is having a problem while import using IMPDP, which poses us some questions here.
The impdp is hung or just processing at constraints enabling around 7000+ (massive 2TB database) and apparently ran for 3 days.
Note, He had already used parallel = 10.
Now question is,
1) Does parallel clause work to create indexes in parallel to expedite the impdp processes?
2) Does parallel clause work to create/enable constraints in parallel to speed up the impdp?
How we all can help him in this case? What are all the solutions we have?
Every suggestion is valuable and may throw or shed some light into new theory.
Looking ahead for your knowledge here.
I will list all possibilities or solutions (of course my friend has already one) later once I got some inputs from you all.
-Thanks
Geek DBA
exclude=indexes
exclude=constraints
sqlfile=indexes.sql
split the .sql file and execute it separately