Synopsis
ALTER VIEW
[schema
.]view_name
COMPILE
Recompiles a view (view_name). The COMPILE
keyword is required.
Notes
You must own this view or have the ALTER ANY VIEW privilege to issue
this command. This command is recommended after changes are made to
any of the underlying base tables.
Example
The following example recompiles scott’s emploc view:
ALTER VIEW scott.emploc RECOMPILE