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 will be available on generic Linux platforms in January and soon on AIX and Windows

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