Why does Data Pump Import hit resumable wait during FULL import
I am attempting to migrate an Oracle 11g R1 (11.1.0.7) Standard Edition database to Oracle 12c R2 using Import/Export with the data pump utilities. Both instances are running on Windows Server but not on the same version.
To do test this process I have:
1) Created an empty database
2) Pre-created all tablespaces in the new locations required, with AUTOEXTEND ON and MAXSIZE UNLIMITED
3) Pre-created all schema owners/users
4) Exported the 11g R1 database with expdp full=yes ...
5) Created a parfile for impdp
Environment:
EXPORT is from database SE 11.1.0.7 (single instance)
Export: Release: 11.1.0.7
IMPORT is to database SE-2 12.2.1.x (single instance)
Import: Release 12.1.0.2.0