OraFAQ Forum: Server Administration » Identify DB Objects related to the table.

Home » RDBMS Server » Server Administration » Identify DB Objects related to the table.

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

Identify DB Objects related to the table. [message #57183]

Tue, 27 May 2003 00:47

DB Patil
Messages: 1
Registered: May 2003

Junior Member

Hi,

In my program , I am using Oracle Procedures,Structs and Varray. And having arpund 40 tables ,100 Procedure, 60 Structs and varray.
Since two of the tables got altered, I want to identify the dependent objects( Procedure/Struct/Varray) for these table.

If any one is having a solution for these, pl.reply asap

Report message to a moderator

Re: Identify DB Objects related to the table. [message #57191 is a reply to message #57183]

Tue, 27 May 2003 11:50

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

mag@itloaner1_local > ED
Wrote file afiedt.buf

  1* select NAME,TYPE from user_dependencies where REFERENCED_NAME='EMP'
mag@itloaner1_local > /

NAME                 TYPE
-------------------- ------------
TEST1                PROCEDURE
LAWSON_ETL           PACKAGE BODY
TEST                 PROCEDURE

Report message to a moderator

Previous Topic:	NLS parameters and no difference between small case and capital
Next Topic:	Problem with Analyze

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:58:17 CDT 2024