Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ROLLBACK clause of Snapshots/materialized views

ROLLBACK clause of Snapshots/materialized views

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Wed, 16 Aug 2000 04:17:03 GMT
Message-ID: <37b78ce6.3257924@news.earthlink.net>

I don't exactly understand how this can be useful... Can somebody explain?
if I set 'master' to some big rollback segment, will my snapshot logs update w/o problems? (currently snapshot log updates cause 'rollback too small 'occasionally)

Thanx.

 USING ROLLBACK SEGMENT
 specifies the remote rollback segment to be used during materialized view refresh, where rollback_segment is the name of the rollback segment to be used. (To change the local materialized view rollback segment, use the DBMS_REFRESH package, described in Oracle8i Replication.)     

 DEFAULT specifies that Oracle will choose automatically which rollback segment to use. If you specify DEFAULT, you cannot specify rollback_segment. (Note: DEFAULT is most useful when modifying a materialized view, as described in "ALTER MATERIALIZED VIEW / SNAPSHOT".) MASTER specifies the remote rollback segment to be used at the remote master for the individual materialized view.

LOCAL specifies the remote rollback segment to be used for the local refresh group that contains the materialized view.

 If you do not specify MASTER or LOCAL, Oracle uses LOCAL by default. If you do not specify rollback_segment, Oracle automatically chooses the rollback segment to be used.

The master rollback segment is stored on a per-materialized-view basis and is validated during materialized view creation and refresh. If the materialized view is complex, the master rollback segment, if specified, is ignored.   Received on Tue Aug 15 2000 - 23:17:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US