OraFAQ Forum: Server Administration » Check view consists of which tables

Home » RDBMS Server » Server Administration » Check view consists of which tables

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

Check view consists of which tables [message #232667]

Sun, 22 April 2007 22:08

*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia

Member

Hi,

How can I check on the base table of each view?

Thank you.

Report message to a moderator

Re: Check view consists of which tables [message #232668 is a reply to message #232667]

Sun, 22 April 2007 22:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> desc user_views

Report message to a moderator

Re: Check view consists of which tables [message #232669 is a reply to message #232667]

Sun, 22 April 2007 22:13

*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia

Member

There is no table name.

SQL> desc dba_views;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(30)
VIEW_NAME NOT NULL VARCHAR2(30)
TEXT_LENGTH NUMBER
TEXT LONG
TYPE_TEXT_LENGTH NUMBER
TYPE_TEXT VARCHAR2(4000)
OID_TEXT_LENGTH NUMBER
OID_TEXT VARCHAR2(4000)
VIEW_TYPE_OWNER VARCHAR2(30)
VIEW_TYPE VARCHAR2(30)

Report message to a moderator

Re: Check view consists of which tables [message #232670 is a reply to message #232667]

Sun, 22 April 2007 22:15

*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia

Member

Hi,

Got it, thanks.

Report message to a moderator

Re: Check view consists of which tables [message #232679 is a reply to message #232667]

Mon, 23 April 2007 00:08

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

SQL> create view v as select * from t;

View created.

SQL> select referenced_owner, referenced_name, referenced_type
  2  from user_dependencies 
  3  where name='V' and type='VIEW';
REFERENCED_OWNER               REFERENCED_NAME                REFERENCED_TYPE
------------------------------ ------------------------------ -----------------
MICHEL                         T                              TABLE

1 row selected.

Regards
Michel

Report message to a moderator

Previous Topic:	Strange Trouble with 10g R2 EM
Next Topic:	DBID

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 23:27:30 CDT 2024