Oracle DBMS_CAPTURE_PROCESS
Version 21c

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 Support for Log Mining and transaction capture.
AUTHID DEFINER
Dependencies
DBMS_CAPTURE_ADM_INTERNAL DBMS_SYS_ERROR V$ARCHIVED_LOG
DBMS_LOGMNR_SESSION_INT LOGMNR_BUILDLOG V$CONTAINERS
DBMS_LOGREP_UTIL LOGMNR_LOG$ V$DATABASE
DBMS_STANDARD LOGMNR_RESTART_CKPT$ V$LOG
DBMS_SYSTEM STREAMS$_CAPTURE_PROCESS V$LOGFILE
Documented No
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvthcap.plb
{ORACLE_HOME}/rdbms/admin/prvtbcap.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_CAPTURE_ADM
DBMS_CAPTURE_ADM_INTERNAL
DBMS_CAPTURE_ADM_IVK
DBMS_CAPTURE_SWITCH_ADM
DBMS_CAPTURE_SWITCH_INTERNAL
DBMS_LOGMNR
DBMS_LOGMNR_D
What's New In 21c
What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx