Home » SQL & PL/SQL » SQL & PL/SQL » Search particular object used in any of my PL/SQL code (merged 3)
Search particular object used in any of my PL/SQL code (merged 3) [message #397126] Thu, 09 April 2009 02:55 Go to next message
etl_prasad
Messages: 44
Registered: June 2005
Location: Scotland
Member
Hi,

I have an requirement to get usage details of a table.

Description:

In our code we are using one particular remote table in our package with the help of DB link i want to know where else it is being used by.

Suppose if i have a table 'test' in x database

i want to know what all code* is using this particular table in working database.

Code Describes:
1)procedure
2)function
3)packages

is it possible ? i tried searching the entire forum with multiple keywords,, and tried at oracle documentation itself.

Please help me out by giving your suggestion..


Thanks in advance..

Re: Search particular object been used in any of my PL/SQL code! [message #397131 is a reply to message #397126] Thu, 09 April 2009 03:03 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
DBA_DEPENDENCIES
Re: Search particular object been used in any of my PL/SQL code! [message #397212 is a reply to message #397131] Thu, 09 April 2009 07:49 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
http://www.orafaq.com/forum/m/390943/136607/#msg_390943

Regards
Sriram
Previous Topic: Regular Express for searching Name
Next Topic: account lock privileges
Goto Forum:
  


Current Time: Fri Dec 02 12:04:47 CST 2016

Total time taken to generate the page: 0.13953 seconds