Oracle | DBMS_SHARED_CAPTURE

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

AUTHID DEFINER

Dependencies

ALL_SCHEDULER_JOBS	DBMS_ASSERT	DBMS_STREAMS_ADM_UTL
CDB_CAPTURE	DBMS_CAPTURE_ADM	DBMS_SYSTEM
CDB_SHARED_CAPTURE_PDBS	DBMS_CAPTURE_ADM_INTERNAL	DBMS_XSTREAM_GG_ADM
DBA_CAPTURE	DBMS_CAPTURE_ADM_IVK	DUAL
DBA_PDBS	DBMS_LOGREP_LIB	GG$SHAREDCAP_SEQ$
DBA_QUEUES	DBMS_LOGREP_UTIL	GG$SHARED_CAPTURE
DBA_QUEUE_TABLES	DBMS_SCHEDULER	GV$GOLDENGATE_CAPTURE
DBA_SHARED_CAPTURE	DBMS_SHARED_CAPTURE_ADM	STREAMS$_CAPTURE_PROCESS
DBA_SHARED_CAPTURE_PDBS	DBMS_SHARED_CAPTURE_IVK	V$PARAMETER
DBA_TAB_PARTITIONS	DBMS_STANDARD	_CDB_CAPTURE
DBMS_AQADM	DBMS_STREAMS_ADM

Documented No

Exceptions

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

First Available 23.1

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	FREECHANGETABLESPACE
ALTER_QUEUE_TABLE	GETFIRSTLCRSCN
COPYPDBCHANGETABLE	GETNEXTCAPTUREID
CREATE_LM_SESSION	GET_RECOVERY_SCN
CREATE_PURGE_CHANGE_TABLE_JOB	MIGRATE_ALL_GG_CAPTURES
DELETE_PROPERTIES	PURGE_ALL_CHANGE_TABLES
DROP_CAPTURE	PURGE_ONE_CHANGE_TABLE
DROP_CATURE_INSTANCES	REGISTERREMOTELMSESIONS
DROP_LM_SESSION	SET_UP_QUEUE
DROP_PURGE_CHANGE_TABLE_JOB	START_CAPTURES
ENABLECOPYCHANGETABLEJOB	STOP_CAPTURES
ENABLE_CAPTURE_MIGRATION_JOB	UPSERT_PROPERTIES
ENABLE_PURGE_CHANGE_TABLE_JOB

ALTER_CAPTURE (new 23c)

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

TBD

ALTER_QUEUE_TABLE (new 23c)

Undocumented dbms_shared_capture_internal.alter_queue_table( queue_table_name IN VARCHAR2, primary_instance IN BINARY_INTEGER, secondary_instance IN BINARY_INTEGER);

TBD

COPYPDBCHANGETABLE (new 23c)

Undocumented dbms_shared_capture.copyPDBChangeTable( 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 23c)

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 23c)

Undocumented dbms_shared_capture_internal.create_purge_change_table_job;

exec dbms_shared_capture_internal.create_purge_change_table_job;

DELETE_PROPERTIES (new 23c)

Undocumented dbms_shared_capture_internal.delete_properties;

TBD

DROP_CATURE (new 23c)

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

TBD

DROP_CATURE_INSTANCES (new 23c)

Undocumented dbms_shared_capture_internal.drop_capture_instances(numinstances IN BINARY_INTEGER);

TBD

DROP_LM_SESSION (new 23c)

Undocumented dbms_shared_capture_internal.drop_lm_session(capture_name IN VARCHAR2);

TBD

DROP_PURGE_CHANGE_TABLE_JOB (new 23c)

Undocumented dbms_shared_capture_internal.drop_purge_change_table_job;

TBD

ENABLECOPYCHANGETABLEJOB (new 23c)

Undocumented dbms_shared_capture_internal.enableCopychangeTableJob(canon_pdb_name IN VARCHAR2);

TBD

ENABLE_CAPTURE_MIGRATION_JOB (new 23c)

Undocumented dbms_shared_capture_internal.enable_capture_migration_job( usesharedcapmode IN BINARY_INTEGER);

TBD

ENABLE_PURGE_CHANGE_TABLE_JOB (new 23c)

Undocumented dbms_shared_capture_internal.enable_purge_change_table_job;

TBD

FREECHANGETABLESPACE (new 23c)

Undocumented dbms_shared_capture_internal.freeChangeTablespace( canon_change_table_name IN VARCHAR2, partitiontruncated OUT BINARY_INTEGER);

TBD

GETFIRSTLCRSCN (new 23c)

Undocumented dbms_shared_capture_internal.getFirstLCRSCN( chgtblname IN VARCHAR2, pdb_id IN BINARY_INTEGER) RETURN NUMBER;

TBD

GETNEXTCAPTUREID (new 23c)

Undocumented dbms_shared_capture_internal.getNextCaptureId RETURN BINARY_INTEGER;

TBD

GET_RECOVERY_SCN (new 23c)

Undocumented dbms_shared_capture_internal.get_recovery_scn(canon_cap_name IN VARCHAR2) RETURN NUMBER;

TBD

MIGRATE_ALL_GG_CAPTURES (new 23c)

Undocumented dbms_shared_capture_internal.migrate_all_gg_captures(usesharedcapmode IN BINARY_INTEGER);

TBD

PURGE_ALL_CHANGE_TABLES (new 23c)

Undocumented dbms_shared_capture_internal.purge_all_change_tables;

TBD

PURGE_ONE_CHANGE_TABLE (new 23c)

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 23c)

Undocumented dbms_shared_capture_internal.registerRemoteLMSesions;

exec dbms_shared_capture_internal.registerRemoteLMSesions;

      *

      ERROR at line 1:

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

      

      ALTER SESSION SET CONTAINER=PDBDEV;

      

      Session altered.

      

      exec dbms_shared_capture_internal.registerRemoteLMSesions;

      *

      ERROR at line 1:

      ORA-01403: no data found

SET_UP_QUEUE (new 23c)

Undocumented dbms_shared_capture_internal.set_up_queue( canon_capture IN VARCHAR2, qual_qname OUT VARCHAR2);

TBD

START_CAPTURES (new 23c)

Undocumented dbms_shared_capture_internal.start_captures;

TBD

STOP_CAPTURES (new 23c)

Undocumented dbms_shared_capture_internal.stop_captures;

TBD

UPSERT_PROPERTIES (new 23c)

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