Re: Discovering the definition for a view?

Van Messner wrote:
>
> Well, Enterprise Manager will certainly make life easier but
> you can look at data dictionary views user_views, all_views or
> dba_views to get the information.
>
> You can use "alter view x" to recompile x. To change the
> structure of a view you drop it and create a new one.
>
> Van
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!

or you can use "create or replace"

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse