OraFAQ Forum: Server Administration » To get all the views pointing to a particular table

Home » RDBMS Server » Server Administration » To get all the views pointing to a particular table

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

To get all the views pointing to a particular table [message #172352]

Tue, 16 May 2006 03:04

kmsalih
Messages: 197
Registered: March 2006

Senior Member

hi all,

i'm trying to get the list of all views pointing to a particular table using DBMS_METADATA Package.

But not possible to get the list when using the get_dependent_ddl function.

I will demonstrate my problem through an example.

EMP TABLE.

Create view v1 as select ename from emp where deptno=10;
Create view v2 as select ename from emp where deptno=20;
Create view v3 as select ename from emp where deptno=30;

I want to get the list of all the three views pointing to emp table.

Thanks in Advance
Salih Km

Report message to a moderator

Re: To get all the views pointing to a particular table [message #172366 is a reply to message #172352]

Tue, 16 May 2006 03:57

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

Senior Member
Account Moderator

 SCOTT > select name,type,referenced_type,referenced_name from user_dependencies where referenced_name='EMP';

NAME                           TYPE              REFERENCED_TYPE   REFERENCED_NAME
------------------------------ ----------------- ----------------- --------------------
V1                             VIEW              TABLE             EMP
V2                             VIEW              TABLE             EMP
V3                             VIEW              TABLE             EMP

Report message to a moderator

Previous Topic:	Password For SYS User
Next Topic:	database starting problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:26:56 CDT 2024