Oracle Distributed Systems

Name

DBMS_REFRESH.MAKE

Synopsis

Call the MAKE procedure to create a snapshot group. The specifications for the Oracle7 and Oracle8 versions differ as follows.

Oracle7 specification:

PROCEDURE DBMS_REFRESH.MAKE
   (name IN VARCHAR2,
   {list IN VARCHAR2, | tab IN dbms_utility.uncl_array,}
    next_date IN DATE,
    interval IN VARCHAR2,
    implicit_destroy IN BOOLEAN DEFAULT FALSE,
    lax IN BOOLEAN DEFAULT FALSE,
    job IN BINARY_INTEGER DEFAULT 0,
    rollback_seg IN VARCHAR2 DEFAULT NULL,
    push_deferred_rpc IN BOOLEAN DEFAULT TRUE,
    refresh_after_errors IN BOOLEAN DEFAULT FALSE );

Oracle8 specification:

PROCEDURE DBMS_REFRESH.MAKE
   (name IN VARCHAR2,
   {list IN VARCHAR2, | tab IN dmbs_utility.uncl_array,}
    next_date IN DATE,
    interval IN VARCHAR2,
    implicit_destroy IN BOOLEAN := FALSE,
    lax IN BOOLEAN := FALSE,
    job IN BINARY_INTEGER := 0,
    rollback_seg IN VARCHAR2 := NULL,
    push_deferred_rpc IN BOOLEAN := TRUE,
    refresh_after_errors IN BOOLEAN := FALSE,
    purge_option  IN BINARY_INTEGER := 1,
    parallelism IN BINARY_INTEGER := 0,
    heap_size IN BINARY_INTEGER := 0);

The MAKE procedure does not raise any exceptions.

Parameters

Parameter Name	Description
name	Name of the refresh group to create.
list	A comma-delimited string of snapshots to include in the new refresh group. Use either list or tab to specify the snapshot(s) you want to add.
tab	A PL/SQL table of snapshots to include in the new refresh group. Use either list or tab to specify the snapshot(s) you want to add.
next_date	The time of the next refresh.
interval	A DATE expression indicating ...