Home » RDBMS Server » Server Administration » How to Find the user tables that are not referenced by any DB object (Oracle 9i on windows)
How to Find the user tables that are not referenced by any DB object [message #305582] Tue, 11 March 2008 05:37 Go to next message
hari_bk
Messages: 110
Registered: March 2006
Senior Member
I need a PL/SQL block that generates a list of all user tables that are not referenced by any DB objects like Package,procedure or Function.

Thanks in advance.

HK
Re: How to Find the user tables that are not referenced by any DB object [message #305594 is a reply to message #305582] Tue, 11 March 2008 05:55 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
And what have you tried so far?
Re: How to Find the user tables that are not referenced by any DB object [message #305599 is a reply to message #305582] Tue, 11 March 2008 06:10 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query dba_dependencies.
But what if there are dynamic statements?

Regards
Michel
Previous Topic: Locking problem
Next Topic: ORACLE not available
Goto Forum:
  


Current Time: Fri Dec 02 14:16:26 CST 2016

Total time taken to generate the page: 0.11892 seconds