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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to found out which views/Stored Proc/Packages having dependencies on database link

dba.arnabJul 30 2013 — edited Jul 31 2013

Hello,

I need some expert's help regarding to find out any probable way to get dependent view/store proc/packages or any other db objects those are using any particular DB Link. Be specific, I have a list of PUBLIC DB LINK in my database. wanted to drop those. I need to confirm that there are not any dependency on those PUBLIC DB LINKS.

Please help.

Regards

Sinha

Oracle DBA

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 28 2013

Added on Jul 30 2013

#general-database-discussions

14 comments

6,889 views