|
|
ALTER VIEW
Recompile a view.
Syntax:
ALTER VIEW [schema.]view COMPILE
An alternative to ALTER VIEW COMPILE is the built-in pl/sql package DBMS_UTILITY
"The truth is not always the same as the majority decision"
- Pope
John XXII
Related Commands:
CREATE VIEW
DROP VIEW
Related Views:
DBA_VIEWS ALL_VIEWS USER_VIEWS V$FIXED_VIEW_DEFINITION Materialised views: DBA_MVIEWS