Oracle | DBMS_CAPTURE

Oracle DBMS_CAPTURE_PROCESS Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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
{ORACLE_HOME}/rdbms/admin/prvtbcap.plb

Subprograms

CLONE_LOGMNR_SESSION	IS_DICTIONARY_MINED
CLONE_LOGMNR_SESSION_CKPTFRE	WAIT_FOR_DICTIONARY_DUMP
GET_CAPTURE#

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