OraFAQ Forum: Weblogic & Application Server » finding objects using a view

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » finding objects using a view

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

finding objects using a view [message #160602]

Mon, 27 February 2006 09:52

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?

Report message to a moderator

Re: finding objects using a view [message #160630 is a reply to message #160602]

Mon, 27 February 2006 14:55

andrew again
Messages: 2577
Registered: March 2000

Senior Member

create or replace view APPS_OBJECTS as
select * from DBA_OBJECTS where OWNER in ('HR',...);

Report message to a moderator

Re: finding objects using a view [message #160838 is a reply to message #160630]

Tue, 28 February 2006 10:46

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.

Report message to a moderator

Previous Topic:	Oracle 9i AS - Performance Issue
Next Topic:	Oracle Wallet

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 22:41:00 CST 2025