Skip to Main Content
Oracle Distributed Systems
book

Oracle Distributed Systems

by Charles Dye
April 1999
Intermediate to advanced content levelIntermediate to advanced
552 pages
15h 39m
English
O'Reilly Media, Inc.
Content preview from Oracle Distributed Systems

Name

DBMS_OFFLINE_SNAPSHOT.BEGIN_LOAD

Synopsis

Call the BEGIN_LOAD procedure from the new snapshot site prior to importing the SNA P$table_name tables that were exported from the master site. This call creates empty snapshots and supporting objects. The specifications for the Oracle7 and Oracle8 versions differ as follows.

Oracle7 specification:

PROCEDURE DBMS_OFFLINE_SNAPSHOT.BEGIN_LOAD
   (gname IN VARCHAR2,
    sname IN VARCHAR2,
    master_site IN VARCHAR2,
    snapshot_oname IN VARCHAR2,
    storage_c IN VARCHAR2 := '',
    comment IN VARCHAR2 := '');

Oracle8 specification:

PROCEDURE DBMS_OFFLINE_SNAPSHOT.BEGIN_LOAD
   (gname IN VARCHAR2,
    sname IN VARCHAR2,
    master_site IN VARCHAR2,
    snapshot_oname IN VARCHAR2,
    storage_c IN VARCHAR2 := '',
    comment IN VARCHAR2 := '',
    min_communication IN BOOLEAN := TRUE );

The BEGIN_LOAD procedure does not raise any exceptions.

Parameters

Parameter Name

Description

gname

The replication group to which the new snapshot belongs.

sname

The schema that owns the new snapshot.

master_site

The global name of the snapshot master site.

snapshot_oname

The name of the temporary snapshot created at the master site.

storage_c

Optional storage clause for the new snapshot.

comment

Optional comment for the snapshot; stored with entry in DBA_SNAPSHOTS if supplied.

min_communication

(Oracle8 only)

The min_communication parameter controls how the update trigger on updateable snapshot queues changes back to the master site. If this parameter is set to TRUE (the default), then old column values are sent only if ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Expert Oracle RAC 12c

Expert Oracle RAC 12c

Syed Jaffar Hussain, Tariq Farooq, Riyaj Shamsudeen, Kai Yu
Expert Oracle Exadata, Second Edition

Expert Oracle Exadata, Second Edition

Martin Bach, Karl Arao, Andy Colvin, Frits Hoogland, Randy Johnson, Kerry Osborne, Tanel Poder

Publisher Resources

ISBN: 1565924320Supplemental ContentCatalog PageErrata