Database Utilities (MOSC)

MOSC Banner

Why does Data Pump Import hit resumable wait during FULL import

edited May 30, 2017 8:05PM in Database Utilities (MOSC) 2 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center