Home » RDBMS Server » Performance Tuning » Source of views (Oracle 10g)
Source of views [message #340310] Tue, 12 August 2008 05:05 Go to next message
hidnana
Messages: 87
Registered: November 2007
Location: chennai
Member
How do we check the source of a view is by dblink or a synonym or a table. we can see the script by going to the DBA_VIEWS and manually check each table. Is there any other way ?

Report message to a moderator

Re: Source of views [message #340317 is a reply to message #340310] Tue, 12 August 2008 05:30 Go to previous message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dbms_metadata.

Regards
Michel

Report message to a moderator

Previous Topic: oracle instance log increased
Next Topic: Query execution estimation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jun 27 20:56:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.