Oracle DBMS_CAPTURE_PROCESS
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 Support for Log Mining and transaction capture.
AUTHID DEFINER
Dependencies
DBMS_CAPTURE_ADM_INTERNAL DBMS_SYSTEM STREAMS$_CAPTURE_PROCESS
DBMS_LOGMNR_SESSION_INT DBMS_SYS_ERROR V$ARCHIVED_LOG
DBMS_LOGREP_UTIL LOGMNR_LOG$ V$DATABASE
DBMS_STANDARD LOGMNR_RESTART_CKPT$  
Documented No
First Available Not Known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvthcap.plb
Subprograms
 
CLONE_LOGMNR_SESSION
Clones a log miner session dbms_capture_process.clone_logmnr_session(
canon_qowner       IN  VARCHAR2,
canon_qname        IN  VARCHAR2,
canon_src_dbname   IN  VARCHAR2,
canon_capture_name IN  VARCHAR2,
start_scn          IN  NUMBER,
clone_appstate_cap IN  NUMBER,
FIRST_SCN          OUT NUMBER,
cloned_sess        OUT NUMBER,
orig_oldest_scn    OUT NUMBER,
canon_flags        IN  NUMBER,
share_sid          IN  NUMBER);
TBD
 
CLONE_LOGMNR_SESSION_CKPTFRE
Clones a log miner session dbms_capture_process.clone_logmnr_session_ckptfre(
canon_qowner       IN  VARCHAR2,
canon_qname        IN  VARCHAR2,
canon_src_dbname   IN  VARCHAR2,
canon_capture_name IN  VARCHAR2,
s_scn              IN  NUMBER,
f_scn              OUT NUMBER,
cloned_sess        OUT NUMBER,
orig_oldest_scn    OUT NUMBER,
canon_flags        IN  NUMBER,
share_sid          IN  NUMBER);
TBD
 
GET_CAPTURE#
Returns the capture id corresponding to a capture name dbms_capture_process.get_capture#(canon_capture_name IN VARCHAR2)
RETURN BINARY_INTEGER;
TBD
 
IS_DICTIONARY_MINED
Outputs a status indicating whether the data dictionary is being mined by the session dbms_capture_process.is_dictionary_mined(
logminer_sid IN  NUMBER,
status       OUT NUMBER);
TBD
 
WAIT_FOR_DICTIONARY_DUMP
Undocumented dbms_capture_process.wait_for_dictionary_dump(
canon_capture_name IN  VARCHAR2,
logminer_sid       IN  NUMBER,
first_scn          IN  NUMBER,
downstream_cap     IN  NUMBER,
end_scn            OUT NUMBER,
status             OUT NUMBER,
missing_log_info   OUT VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_LOGMNR
DBMS_LOGMNR_D
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