ALTER VIEW

Recompile a view.

Syntax:

   ALTER VIEW [schema.]view COMPILE


"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