Oracle | DBMS_SHARED_CAPTURE

Oracle DBMS_SHARED_CAPTURE_IVK Version 23c

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 Administration utilities for Shared Capture administration.

AUTHID CURRENT_USER

Dependencies

DBA_CAPTURE	DBMS_STREAMS_DECL
DBA_QUEUE_TABLES	DBMS_UTILITY
DBA_SHARED_CAPTURE	DBMS_XSTREAM_ADM_UTL
DBA_SHARED_CPATURE_PDBS	DBMS_XSTREAM_GG_ADM
DBMS_ASSERT	DUAL
DBMS_CAPTURE_ADM_INTERNAL	GLOBAL_NAME
DBMS_LOGMNR_INTERNAL	GV_$GOLDENGATE_CAPTURE
DBMS_LOGREP_LIB	GV$_INSTANCE
DBMS_LOGREP_UTIL	STREAMS$_RULES
DBMS_SHARED_CAPTURE_ADM	V_$DATABASE
DBMS_SHARED_CAPTURE_INTERNAL	V_$PARAMETER
DBMS_STANDARD	V_$PDBS
DBMS_STREAMS_ADM_UTL

Documented No

First Available 23.1

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvthcap.plb
{ORACLE_HOME}/rdbms/admin/prvtbcap.plb

Subprograms

ALTER_CAPTURE	DROP_CAPTURE	ROOT_CONTAINER_CHECK
CREATE_CAPTURE	REGISTER_PDB	UNREGISTER_PDB

ALTER_CAPTURE (new 23c)

Undocumented dbms_shared_capture_ivk.alter_capture( capture_name IN VARCHAR2, primary_instance IN BINARY_INTEGER, secondary_instance IN BINARY_INTEGER);

TBD

CREATE_CAPTURE (new 23c)

Undocumented dbms_shared_capture_ivk.create_capture( capture_name IN VARCHAR2, canon_tblspc IN VARCHAR2, clone_lm_session IN BOOLEAN);

TBD

DROP_CAPTURE (new 23c)

Undocumented dbms_shared_capture_ivk.drop_capture( capture_name IN VARCHAR2, force IN BOOLEAN);

TBD

REGISTER_PDB (new 23c)

Undocumented dbms_shared_capture_ivk.register_pdb( capture_name IN VARCHAR2, source_pdb_name IN VARCHAR2, first_scn OUT NUMBER, start_scn OUT NUMBER);

TBD

ROOT_CONTAINER_CHECK (new 23c)

Undocumented dbms_shared_capture_ivk.root_container_check; PL/SQL procedure successfully completed.

exec dbms_shared_capture_ivk.root_container_check;

      

      PL/SQL procedure successfully completed.

UNREGISTER_PDB (new 23c)

Undocumented dbms_shared_capture_ivk.unregister_pdb( capture_name IN VARCHAR2, source_pdb_name IN VARCHAR2);

TBD