Oracle | DBMS_CAPTURE_SWITCH

Oracle DBMS_CAPTURE_SWITCH_ADM Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Undocumented Streams/GoldenGate Capture Support

AUTHID CURRENT_USER

Dependencies

DBA_CAPTURE	DBMS_CAPTURE_SWITCH_INTERNAL	DBMS_STREAMS_RPC
DBA_PROPAGATION	DBMS_LOGREP_UTIL	DBMS_SYSTEM
DBMS_CAPTURE_ADM	DBMS_OUTPUT	_GV$SXGG_CAPTURE

Documented No

First Available Not Known

Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role

Source {ORACLE_HOME}/rdbms/admin/prvthscp.plb

Subprograms

GET_SOURCE_DATABASE_SCNS

SWITCH_TO_APPLY_STATE_CKPT

SWITCH_TO_CHECKPOINTS

GET_SOURCE_DATABASE_SCNS

Returns the current SCN and the minimum capture SCN dbms_capture_switch_adm.get_source_database_scns( current_scn OUT NUMBER, min_start_scn OUT NUMBER);

set serveroutput on

      

      DECLARE

       curSCN NUMBER;

       minSCN NUMBER;

      BEGIN

        dbms_capture_switch_adm.get_source_database_scns(curSCN, minSCN);

      END;

      /

SWITCH_TO_APPLY_STATE_CKPT

dbms_capture_switch_adm.switch_to_apply_state_ckpt capture_name IN VARCHAR2, scn_range IN NUMBER, current_scn IN NUMBER, min_start_scn IN NUMBER, wait_interval IN NUMBER, max_wait IN NUMBER);

TBD

SWITCH_TO_CHECKPOINTS

dbms_capture_switch_adm.switch_to_checkpoints( capture_name IN VARCHAR2, wait_interval IN NUMBER, max_wait IN NUMBER);

TBD