Oracle | DBMS_SHARED_CAPTURE

Oracle DBMS_SHARED_CAPTURE_INTERNAL 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 Internal utilities for Shared Capture administration.

AUTHID DEFINER

Dependencies

ALL_SCHEDULER_JOBS	DBMS_LOGREP_UTIL_INVOK
CDB_CAPTURE	DBMS_SCHEDULER
CDB_SHARED_CAPTURE_PDBS	DBMS_SHARED_CAPTURE_ADM
CHANGE_TABLE_INFO$	DBMS_SHARED_CAPTURE_IVK
DBA_CAPTURE	DBMS_SQL
DBA_QUEUES	DBMS_STANDARD
DBA_QUEUE_TABLES	DBMS_STREAMS_ADM
DBA_SCHEDULER_JOBS	DBMS_STREAMS_ADM_UTL
DBA_SHARED_CAPTURE	DBMS_SYSTEM
DBA_SHARED_CAPTURE_CHANGE_TABLES	DUAL
DBA_SHARED_CAPTURE_PDBS	GG$SHAREDCAP_SEQ$
DBMS_ASSERT	GG$SHARED_CAPTURE
DBMS_CAPTURE_ADM	GV$CONTAINER_TOPOLOGY
DBMS_CAPTURE_ADM_INTERNAL	GV$GOLDENGATE_CAPTURE
DBMS_CAPTURE_ADM_IVK	STREAMS$_CAPTURE_PROCESS
DBMS_CHANGE_TABLE_ADM	V$INSTANCE
DBMS_LOGREP_LIB	V$PARAMETER
DBMS_LOGREP_UTIL	WRM$_DATABASE_INSTANCE

Documented No

Exceptions

Error Code	Reason
`ORA-65046`	`operation not allowed from outside a pluggable database`

First Available 23ai

Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role.

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

Subprograms

ALTER_CAPTURE	ENABLE_CAPTURE_MIGRATION_JOB
COPY_PDB_CHANGE_TABLE	ENABLE_PURGE_CHANGE_TABLE_JOB
CREATE_LM_SESSION	GETNEXTCAPTUREID
CREATE_PURGE_CHANGE_TABLE_JOB	MIGRATE_ALL_GG_CAPTURES
DELETE_PROPERTIES	PURGE_ALL_CHANGE_TABLES
DROP_CAPTURE	PURGE_ONE_CHANGE_TABLE
DROP_CAPTURE_INSTANCES	REGISTERREMOTELMSESIONS
DROP_LM_SESSION	START_CAPTURES
DROP_PURGE_CHANGE_TABLE_JOB	STOP_CAPTURES
ENABLECOPYCHANGETABLEJOB	UPSERT_PROPERTIES

ALTER_CAPTURE (new 23ai)

Undocumented dbms_shared_capture_internal.alter_capture( canon_capture IN VARCHAR2, primary_instance IN BINARY_INTEGER, secondary_instance IN BINARY_INTEGER);

TBD

COPY_PDB_CHANGE_TABLE (new 23ai)

Undocumented dbms_shared_capture.copy_pdb_change_table( canon_pdb_name IN VARCHAR2, unplug_scn IN NUMBER, pdb_cap_oldest_scn IN NUMBER, canon_src_cdb_link IN VARCHAR2);

TBD

CREATE_LM_SESSION (new 23ai)

Undocumented dbms_shared_capture_internal.create_lm_session( capture_name IN VARCHAR2, first_scn IN NUMBER, start_scn IN NUMBER);

TBD

CREATE_PURGE_CHANGE_TABLE_JOB (new 23ai)

Undocumented dbms_shared_capture_internal.create_purge_change_table_job;

exec dbms_shared_capture_internal.create_purge_change_table_job;

DELETE_PROPERTIES (new 23ai)

Undocumented dbms_shared_capture_internal.delete_properties;

TBD

DROP_CATURE (new 23ai)

Undocumented dbms_shared_capture_internal.drop_capture( canon_capture IN VARCHAR2, force IN BOOLEAN);

TBD

DROP_CATURE_INSTANCES (new 23ai)

Undocumented dbms_shared_capture_internal.drop_capture_instances(numinstances IN BINARY_INTEGER);

TBD

DROP_LM_SESSION (new 23ai)

Undocumented dbms_shared_capture_internal.drop_lm_session(capture_name IN VARCHAR2);

TBD

DROP_PURGE_CHANGE_TABLE_JOB (new 23ai)

Undocumented dbms_shared_capture_internal.drop_purge_change_table_job;

TBD

ENABLECOPYCHANGETABLEJOB (new 23ai)

Undocumented dbms_shared_capture_internal.enableCopychangeTableJob(canon_pdb_name IN VARCHAR2);

TBD

ENABLE_CAPTURE_MIGRATION_JOB (new 23ai)

Undocumented dbms_shared_capture_internal.enable_capture_migration_job( usesharedcapmode IN BINARY_INTEGER);

TBD

ENABLE_PURGE_CHANGE_TABLE_JOB (new 23ai)

Undocumented dbms_shared_capture_internal.enable_purge_change_table_job;

TBD

GETNEXTCAPTUREID (new 23ai)

Undocumented dbms_shared_capture_internal.getNextCaptureId RETURN BINARY_INTEGER;

TBD

MIGRATE_ALL_GG_CAPTURES (new 23ai)

Undocumented dbms_shared_capture_internal.migrate_all_gg_captures(usesharedcapmode IN BINARY_INTEGER);

TBD

PURGE_ALL_CHANGE_TABLES (new 23ai)

Undocumented dbms_shared_capture_internal.purge_all_change_tables;

TBD

PURGE_ONE_CHANGE_TABLE (new 23ai)

Undocumented dbms_shared_capture_internal.purge_one_change_table( pdb_name IN VARCHAR2, purge_scn IN NUMBER, max_quota IN NUMBER, tz_offset IN NUMBER);

TBD

REGISTERREMOTELMSESIONS (new 23ai)

Undocumented dbms_shared_capture_internal.registerRemoteLMSesions;

exec dbms_shared_capture_internal.registerRemoteLMSesions;

      *

      ORA-65046: operation not allowed from outside a pluggable database

      

      ALTER SESSION SET CONTAINER=PDBDEV;

      

      Session altered.

      

      exec dbms_shared_capture_internal.registerRemoteLMSesions;

      *

      ORA-01403: no data found

START_CAPTURES (new 23ai)

Undocumented dbms_shared_capture_internal.start_captures;

TBD

STOP_CAPTURES (new 23ai)

Undocumented dbms_shared_capture_internal.stop_captures;

TBD

UPSERT_PROPERTIES (new 23ai)

Undocumented dbms_shared_capture_internal.upsert_properties( canon_tablespace IN VARCHAR2, change_table_retention IN BINARY_INTEGER, change_table_ck_frequency IN BINARY_INTEGER, change_table_part_intv IN BINARY_INTEGER, max_workers IN BINARY_INTEGER, insert_row IN BOOLEAN);

TBD