Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ROLLBACK clause of Snapshots/materialized views
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