Home » RDBMS Server » Server Administration » How to find the base table of a view (11g windows)
How to find the base table of a view [message #519570] Mon, 15 August 2011 00:26 Go to next message
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?

Report message to a moderator

Re: How to find the base table of a view [message #519573 is a reply to message #519570] Mon, 15 August 2011 00:48 Go to previous messageGo to next message
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
Senior Member
dba_views should give you what you need.

Report message to a moderator

Re: How to find the base table of a view [message #519579 is a reply to message #519570] Mon, 15 August 2011 01:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
user/all/dba_dependencies

Regards
Michel

Report message to a moderator

Re: How to find the base table of a view [message #519634 is a reply to message #519579] Mon, 15 August 2011 20:13 Go to previous message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks!

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jan 27 02:55:08 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.