Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to export Synonym where owner=PUBLIC

user10745179Jun 27 2011 — edited Jun 27 2011

Hi,

Im using oracle 11g on AIX 5.3, I have taken the export backup with data pump of one schema. its imported successfully,

but the all synonyms are not imported,

My table onwer is user whose backup i have taken ,
bt the owner of the synonyms are PUBLIC

but synonyms are not reflected in import ? why ? what should be the way to import the synonyms where user is PUBLIC?

Please help?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 25 2011

Added on Jun 27 2011

#general-database-discussions

7 comments

4,293 views