Oracle | DBMS_CAPTURE

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	GET_CAPTURE#	WAIT_FOR_DICTIONARY_DUMP
CLONE_LOGMNR_SESSION_CKPTFRE	IS_DICTIONARY_MINED

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