My Oracle Support Banner

ALTERING A MASTER TABLE OF A READ-ONLY/UPDATABLE SNAPSHOT (Doc ID 1029823.6)

Last updated on AUGUST 04, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.