Home Oracle Commands

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




Back to the Top

Simon Sheppard
SS64.com