Import schemas in 11.20.3 did not imported the public synonyms
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
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
0