Database Utilities (MOSC)

MOSC Banner

Create Type problem in impdp with network_link option

edited May 8, 2015 10:34AM in Database Utilities (MOSC) 2 commentsAnswered ✓

Hello,

Is anybody familiar with the problems of creating types during impdp via network_link option.

Should I import types and other failures with separate imdp on more detailed level ( table level ).

The following command was used for cloning data from one set of schemas to other set of schemas on the same database instance:

nohup impdp userid=target_dba_user/pwd@TARGET_DB schemas=SOURCE_SCHEMA1, SOURCE_SCHEMA2,SOURCE_SCHEMA2 \

remap_schema=SOURCE_SCH1:DEST_SCH1,SOURCE_SCH2:DEST_SCH2,SOURCE_SCH3:DEST_SCH3 network_link=from_destDB_to_sourceDB &

Is there any constraints when using imdp accross db_link for create type?

Tagged:

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