Database Utilities (MOSC)

MOSC Banner

Is Data Pump import from a read-only Data Guard instance into a read-write target instance possible

edited Apr 1, 2013 2:32PM in Database Utilities (MOSC) 2 commentsAnswered
Is Data Pump import from a read-only Data Guard instance into a read-write target instance possible using Data Pump parameter NETWORK_LINK? 

Getting errors ORA-39125 and ORA-00904 occur when doing the import:

impdp ... schemas=...  DIRECTORY=DATA_PUMP_DIR  NETWORK_LINK=...
...
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS while calling DBMS_METADATA.FETCH_XML_CLOB []
ORA-00904: : invalid identifier
ORA-06512: at "SYS.DBMS_METADATA", line 1886
ORA-06512: at "SYS.DBMS_METADATA", line 1923


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