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 will be available on generic Linux platforms in January and soon on AIX and Windows

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