Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 7 of 11
To explicitly recompile a view that is invalid. Explicit recompilation allows you to locate recompilation errors before run time. You may want to recompile a view explicitly after altering one of its base tables to ensure that the alteration does not affect the view or other objects that depend on it.
When you issue an ALTER
VIEW
statement, Oracle recompiles the view regardless of whether it is valid or invalid. Oracle also invalidates any local objects that depend on the view.
Notes:
See Also: Oracle8i Concepts for more about dependencies among schema objects. |
The view must be in your own schema or you must have ALTER
ANY
TABLE
system privilege.
To recompile the view CUSTOMER_VIEW
, issue the following statement:
ALTER VIEW customer_view COMPILE;
If Oracle encounters no compilation errors while recompiling CUSTOMER_VIEW
, CUSTOMER_VIEW
becomes valid. If recompiling results in compilation errors, Oracle returns an error and CUSTOMER_VIEW
remains invalid.
Oracle also invalidates all dependent objects. These objects include any procedures, functions, package bodies, and views that reference CUSTOMER_VIEW
. If you subsequently reference one of these objects without first explicitly recompiling it, Oracle recompiles it implicitly at run time.
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|