IMPDP is Taking Long Time at defining state
IMPDP is Taking Long Time at defining state with SYS User.
Defining State itself taking more than 3 hours and actual data import finishing in 1 hour.
We tried setting all performance parameters but no luck.
Note: We are doing import using sys user in 12c Database (Exported from 11g Database).
After struggling one week still no luck :(
Solution : we tried import with system user by mistake and defining state completed in 2 Minutes :)
use SYSTEM, not SYS on datapump. SYS is only for the legacy exp/imp.
From 12c Use SYSTEM user to avoid Import performance issues.
impdp system/manager dumpfile=test:filename.dmp logfile=test:filename.log
Defining State itself taking more than 3 hours and actual data import finishing in 1 hour.
We tried setting all performance parameters but no luck.
Note: We are doing import using sys user in 12c Database (Exported from 11g Database).
After struggling one week still no luck :(
Solution : we tried import with system user by mistake and defining state completed in 2 Minutes :)
use SYSTEM, not SYS on datapump. SYS is only for the legacy exp/imp.
From 12c Use SYSTEM user to avoid Import performance issues.
impdp system/manager dumpfile=test:filename.dmp logfile=test:filename.log
Comments
Post a Comment