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 extract ddl for all database links?

Mike301Sep 23 2015 — edited Sep 24 2015

DB: oracle11gr2

Friends,

I can get particular db link ddl from the dbms package but couldn't able to figure out way to extract ddl for all database link and spool into a file to recreate them in future?

Tried searching on OTN but no luck, if somebody share how to spool them or point me to particular forum that will be great.

Thanks,

This post has been answered by Mike301 on Sep 24 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 22 2015

Added on Sep 23 2015

#general-database-discussions

9 comments

9,229 views