Oracle | DBMS_CAPTURE_SWITCH

Oracle DBMS_CAPTURE_SWITCH_ADM Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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