OraFAQ Forum: Server Administration » How to find the base table of a view

Home » RDBMS Server » Server Administration » How to find the base table of a view (11g windows)

Mon, 15 August 2011 00:26

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
How to find the base table of a view,such as a view:

create or replace view vw_test as select * from tb_test;

Is there dic view to get the base table of view?

Mon, 15 August 2011 00:48

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

dba_views should give you what you need.

Mon, 15 August 2011 01:45

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

Senior Member
Account Moderator

user/all/dba_dependencies

Regards
Michel

Mon, 15 August 2011 20:13

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks!

Previous Topic:	ORA-19821: an intentionally corrupt log file was found
Next Topic:	Job not running on expected time

Goto Forum:

]

Current Time: Fri Apr 26 17:00:14 CDT 2024