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