Database Utilities (MOSC)

MOSC Banner

Import schemas in 11.20.3 did not imported the public synonyms

edited Feb 18, 2013 10:26AM in Database Utilities (MOSC) 6 commentsAnswered ✓
H experts.
I don't know why the import of schemas did not import the public synonyms.

Import done in 3 steps:

impdp user/pwd dumpfile=dpump_dir1:finprd.dmp logfile=dpump_log1:imp_fincop_meta.log TRANSFORM=oid:n content=METADATA_ONLY TABLE_EXISTS_ACTION=truncate EXCLUDE=CONSTRAINT,REF_CONSTRAINT,INDEX,TRIGGER,USER

impdp user/pwd dumpfile=dpump_dir1:finprd.dmp logfile=dpump_log1:imp_fincop_data.log TRANSFORM=oid:n content=DATA_ONLY TABLE_EXISTS_ACTION=truncate

impdp user/pwd dumpfile=dpump_dir1:finprd.dmp logfile=dpump_log1:imp_fincop_idx.log TRANSFORM=oid:n content=metadata_only INCLUDE=CONSTRAINT,REF_CONSTRAINT,INDEX,TRIGGER

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