ALTERING A MASTER TABLE OF A READ-ONLY/UPDATABLE SNAPSHOT

(Doc ID 1029823.6)

Last updated on JANUARY 20, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 8.0.6.0 to 11.2.0.1 [Release 8.0.6 to 11.2]
Information in this document applies to any platform.

Symptoms



As part of administering your database, it is sometimes necessary to ALTER
the master table of a read-only or updatable materialized view.  

This includes adding a column, dropping a column, changing a column's
datatype, etc.

Note that this note is not intended to cover master table reorganization
(rebuilding a master table), only master table redefinition (altering a
master table).

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms