Oracle DBMS_CAPTURE_SWITCH_ADM
Version 18.3

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Undocumented Streams 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
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

Related Topics
Built-in Functions
Built-in Packages
DBMS_CAPTURE_ADM
DBMS_CAPTURE_SWITCH_INTERNAL
DBMS_LOGREP_UTIL
DBMS_OUTPUT
DBMS_SYSTEM
What's New In 18c
What's New In 19c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx