Re: Discovering the definition for a view?

   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!