Database Utilities (MOSC)

MOSC Banner

impdp using network_link and full=y

edited Feb 25, 2014 12:08PM in Database Utilities (MOSC) 6 commentsAnswered ✓

11.2.0.4 database on Linux x86 64bit

I am trying to move a a database from one server to another using impdp.  The database is approx.100g.  I am using this command:

impdp system/pw network_link=v_prod FULL=Y parallel=8;

I made sure that system on both nodes has sysdba privileges. 

The problem seems to be that users/schemas are not being created so am getting these errors:

ORA-39083: Object type PROCACT_SCHEMA failed to create with error:

ORA-31625: Schema EUL5_US is needed to import this object, but is unaccessible

ORA-01435: user does not exist

I have looked this up on oracle support and can't find anything except that the import SHOULD create the users.

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