Name

DBMS_REFRESH.SUBTRACT

Synopsis

Call the SUBTRACT procedure to subtract a snapshot group.

PROCEDURE DBMS_REFRESH.SUBTRACT
    (name IN VARCHAR2,
    {list IN VARCHAR2,| tab IN dbms_utility.uncl_array,}
     lax IN BOOLEAN DEFAULT FALSE );

The parameters for theSUBTRACT procedure have the same meaning as in the ADD procedure; refer to the parameter table in that section. Note that you must select the list or tab parameter, but not both.

Exceptions

Exception Name

Number

Description

ORA-23404

–23404

Refresh group name does not exist.

Restrictions

This procedure must be run from the snapshot site.

Get Oracle Distributed Systems now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial