Home » SQL & PL/SQL » SQL & PL/SQL » How to get the usage details of column or table ? (Oracle 10 G)
How to get the usage details of column or table ? [message #377221] Sun, 21 December 2008 22:54 Go to next message
rangan.s
Messages: 75
Registered: February 2008
Location: chennai
Member
Hi,

I have an requirement like to get usage details of a column or table . how to acheive this.

Suppose if i have a column 'test_col' in table 'test'

i want to know where all it has been used
1)procedure
2)function
3)packages


how to get this ? is it possible ?

Thanks
Rangan S
Re: How to get the usage details of column or table ? [message #377222 is a reply to message #377221] Sun, 21 December 2008 23:08 Go to previous messageGo to next message
trivendra
Messages: 208
Registered: October 2007
Location: Noida, India
Senior Member
Look for USER_SOURCE.
Re: How to get the usage details of column or table ? [message #377227 is a reply to message #377221] Mon, 22 December 2008 00:20 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8631
Registered: November 2002
Location: California, USA
Senior Member
http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/dependencies.htm#CNCPT1860
Re: How to get the usage details of column or table ? [message #377230 is a reply to message #377227] Mon, 22 December 2008 00:40 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
%DEPENDENCIES views don't track dependencies at column level just at table one.

Regards
Michel
Previous Topic: Dual Column Advance Constraint.
Next Topic: Exception handling
Goto Forum:
  


Current Time: Mon Dec 05 07:05:04 CST 2016

Total time taken to generate the page: 0.28648 seconds