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!

DBMS_METADATA and synonym

573141May 25 2009 — edited May 26 2009

hi gurus,

i understand that using DBMS_METADATA.GET_DDL(SynonymnName, Schema..) it is possilble to generate DDL for a synonym.

i need to generate the DDL for all public/private synonyms associated with a table.
is it possible to use DBMS_METADATA here?

tia,
newbie

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 23 2009

Added on May 25 2009

#general-database-discussions

7 comments

10,383 views