OraFAQ Forum: Server Administration » Object Dependency Report

Home » RDBMS Server » Server Administration » Object Dependency Report

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

Object Dependency Report [message #50800]

Mon, 08 April 2002 10:54

Ronak Bhatt
Messages: 2
Registered: February 2002

Junior Member

Does anyone have a pl/sql - sql script that can tell me about the references that the object has in database e.g. used in view, has synonym, has public synonym, used in procedure, used in package etc.

Thanks,
Ronak

Report message to a moderator

Re: Object Dependency Report [message #50801 is a reply to message #50800]

Mon, 08 April 2002 14:21

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

These two data dictionary queries can show you the various dependencies:

select *
  from all_dependencies
 where referenced_owner = :owner 
   and referenced_name = :name 
   and referenced_type <> 'NON-EXISTENT';
 
select * from all_synonyms
 where table_owner = :owner
   and table_name = :name;

Report message to a moderator

Previous Topic:	Trigger error
Next Topic:	Re: VB-Oracle Connectivity

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 08 10:26:58 CDT 2024