Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » finding objects using a view
finding objects using a view [message #160602] Mon, 27 February 2006 09:52 Go to next message
madchaz
Messages: 65
Registered: October 2005
Member
I need to find all the objects using a custom view in oracle applications.

Anyone as an idea where to start?
Re: finding objects using a view [message #160630 is a reply to message #160602] Mon, 27 February 2006 14:55 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
create or replace view APPS_OBJECTS as
select * from DBA_OBJECTS where OWNER in ('HR',...);
Re: finding objects using a view [message #160838 is a reply to message #160630] Tue, 28 February 2006 10:46 Go to previous message
madchaz
Messages: 65
Registered: October 2005
Member
That gives me who owns the object, but not what is using it.

I ended up finding the information using this.
select * from DBA_DEPENDENCIES WHERE REFERENCED_NAME like 'object'


It found everything internal to the DB that uses it. It doesn't find any external scripts or jsp pages or forms, but does find all the objects in the DB that use it.
Previous Topic: Oracle 9i AS - Performance Issue
Next Topic: Oracle Wallet
Goto Forum:
  


Current Time: Thu Mar 28 09:16:01 CDT 2024