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

Report message to a moderator

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: 2882
Registered: May 2007
Location: Scotland
Senior Member
And what have you tried so far?

Report message to a moderator

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: 68683
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query dba_dependencies.
But what if there are dynamic statements?

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 16 05:12:52 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.