ALTER MATERIALIZED VIEW

Change the properties of an existing mview.
The word "snapshot" is synonymous with "materialized view".

Syntax:

   ALTER MATERIALIZED VIEW [schema.]mview options iot_options
      [USING INDEX index_options]
         [REFRESH [refresh_options]]
            [COMPILE | CONSIDER FRESH | {ENABLE|DISABLE} QUERY REWRITE]

   ALTER MATERIALIZED VIEW [schema.]mview options iot_options
      [USING INDEX index_options]
         [REBUILD]
            [COMPILE | CONSIDER FRESH | {ENABLE|DISABLE} QUERY REWRITE]

   ALTER MATERIALIZED VIEW [schema.]mview options iot_options
      [USING INDEX index_options]
         MODIFY SCOPE FOR (ref_column/attribute) IS [schema.]scope_table
            [COMPILE | CONSIDER FRESH | {ENABLE|DISABLE} QUERY REWRITE]

Options:

   COMPRESS|NOCOMPRESS
   CACHE | NOCACHE
   PARALLEL int | NOPARALLEL
   ALLOCATE EXTENT [( [DATAFILE filename]
                      [, SIZE int {K | M}]
                      [, INSTANCE int] )]
   Partitioning clause
   Physical_options
   LOB Clause

Physical_options:
   PCTFREE int
   PCTUSED int
   INITRANS int
   MAXTRANS int
   STORAGE storage_clause
   LOGGING | NOLOGGING

iot_options:
   [PCTHRESHOLD int ] [INCLUDING column_name] 
      OVERFLOW [TABLESPACE tablespace] Physical_options

   OVERFLOW ALLOCATE EXTENT [( [DATAFILE filename]
                            [, SIZE int {K | M}]
                            [, INSTANCE int] )]
   OVERFLOW DEALLOCATE UNUSED [KEEP int {K | M}]

   ADD OVERFLOW [TABLESPACE tablespace] Physical_options
      [(PARTITION [TABLESPACE tablespace] Physical_options)]

   COALESCE

index_options:
   PCTFREE int
   PCTUSED int
   INITRANS int
   MAXTRANS int
   STORAGE storage_clause

refresh_options:
   FAST | COMPLETE | FORCE
   ON [DEMAND | COMMIT]
   {NEXT | START WITH} date
   WITH PRIMARY KEY
   USING DEFAULT MASTER ROLLBACK SEGMENT
   USING MASTER ROLLBACK SEGMENT rb_segment

Related Commands:

GRANT ALTER ANY MATERIALIZED VIEW
MVIEW - CREATE MATERIALIZED VIEW
MVIEW - DROP MATERIALIZED VIEW
MVIEW LOG - ALTER MATERIALIZED VIEW LOG
DBMS_MVIEW
DBMS_REFRESH

Related Views:

 DBA_MVIEWS                 ALL_MVIEWS           USER_MVIEWS
 DBA_MVIEW_AGGREGATES       ALL_MVIEW_AGGREGATES USER_MVIEW_AGGREGATES
 DBA_MVIEW_ANALYSIS         ALL_MVIEW_ANALYSIS   USER_MVIEW_ANALYSIS
 DBA_MVIEW_DETAIL_RELATIONS ALL_MVIEW_DETAIL_RELATIONS USER_MVIEW_DETAIL_RELATIONS
 DBA_MVIEW_JOINS            ALL_MVIEW_JOINS      USER_MVIEW_JOINS
 DBA_MVIEW_KEYS             ALL_MVIEW_KEYS       USER_MVIEW_KEYS
 DBA_MVIEW_LOGS             ALL_MVIEW_LOGS       USER_MVIEW_LOGS
 DBA_MVIEW_LOG_FILTER_COLS
 DBA_MVIEW_REFRESH_TIMES    ALL_MVIEW_REFRESH_TIMES USER_MVIEW_REFRESH_TIMES


© Copyright SS64.com 1999-2014
Some rights reserved