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 use dbms_metadata.get_ddl to extract PUBLIC Synonyms

user594143Sep 25 2008 — edited Sep 25 2008

My database has more then 2000 PUBLIC synonyms which have to be re created in similar database. I need some help on how to use dbms_metadata.get_ddl to extract all PUBLIC Synonyms DDL

Oracle version: 9i

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 23 2008

Added on Sep 25 2008

#general-database-discussions

10 comments

20,635 views