Oracle | DBMS_CHANGE_TABLE

Oracle DBMS_CHANGE_TABLE_ADM 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 Undocumented

AUTHID DEFINER

Dependencies

CDB_CAPTURE	DBMS_SHARED_CAPTURE_ADM
CDB_SHARED_CAPTURE_PDBS	DBMS_SHARED_CAPTURE_INTERNAL
CHANGE_TABLE_INFO$	DBMS_SHARED_CAPTURE_IVK
DBA_CAPTURE	DBMS_SQL
DBA_SHARED_CAPTURE_CHANGE_TABLES	DBMS_STANDARD
DBA_TAB_PARTITIONS	DBMS_STREAMS_aDM
DBMS_AQADM	DBMS_XSTREAM_GG_ADM
DBMS_ASSERT	PDB_LIFE_SPAN_CATALOG$
DBMS_LOGREP_LIB	STREAMS$_CAPTURE_PROCESS
DBMS_LOGREP_UTIL	V_$PDBS
DBMS_SESSION	_DBA_SHARED_CAP_CHANGE_TABLES

Documented No

First Available 23ai

Pragmas -

Security Model Owned by GGSHAREDCAP with EXECUTE granted to the OGG_SHARED_CAPTURE role.

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

Subprograms

ALTER_QUEUE_TABLE	GET_CHANGE_TABLE_MAX_SCN	PURGE_ONE_CHANGE_TABLE
COPY_PDB_CHANGE_TABLE	GET_RECOVERY_SCN	REMOVE_QUEUE
FREECHANGETABLESPACE	MANAGE_CHANGE_TABLE	SET_UP_QUEUE
GETFIRSTLCRSCN	PREPARE_COPY_CHANGE_TABLE

ALTER_QUEUE_TABLE (new 23ai)

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

TBD

COPY_PDB_CHANGE_TABLE (new 23ai)

Undocumented dbms_change_table_adm.copy_pdb_change_table( canon_pdb_name IN VARCHAR2, canon_capname IN VARCHAR2, chg_tbl_name IN VARCHAR2, canon_src_cdb_link IN VARCHAR2, is_dgpdb IN BINARY_INTEGER);

TBD

FREECHANGETABLESPACE (new 23ai)

Undocumented dbms_change_table_adm.freeChangeTablespace( canon_change_table_name IN VARCHAR2, partition_truncated OUT BINARY_INTEGER);

TBD

GETFIRSTLCRSCN (new 23ai)

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

TBD

GET_CHANGE_TABLE_MAX_SCN (new 23ai)

Undocumented dbms_change_table_adm.get_change_table_max_scan( canon_chgtbl_name IN VARCHAR2, foundcorruptblock IN OUT BOOLEAN, rtn_max_oldest_scn IN BOOLEAN) RETURN NUMBER;

TBD

GET_RECOVERY_SCN (new 23ai)

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

TBD

MANAGE_CHANGE_TABLE (new 23ai)

Undocumented dbms_change_table_adm.manage_change_table( canon_schema IN VARCHAR2, canon_chg_tbl_nm IN VARCHAR2, canon_tablespace IN VARCHAR2, drop_table IN BOOLEAN, pdb_id IN BINARY_INTEGER, pdb_dbid_num IN NUMBER);

TBD

PREPARE_COPY_CHANGE_TABLE (new 23ai)

Undocumented dbms_change_table_adm.prepare_copy_change_table( canon_pdb_name IN VARCHAR2, is_dgpdb IN BINARY_INTEGER, unspill_ct IN BINARY_INTEGER);

TBD

PURGE_ONE_CHANGE_TABLE (new 23ai)

Undocumented dbms_change_table_adm.purge_one_change_table( change_table_name IN VARCHAR2, pdb_name IN VARCHAR2, purge_scn IN NUMBER, max_quota IN NUMBER, tz_offset IN NUMBER, retention_period IN NUMBER, is_table_purged OUT BOOLEAN);

TBD

REMOVE_QUEUE (new 23ai)

Undocumented dbms_change_table_adm.remove_queue(qual_qname IN VARCHAR2);

TBD

SET_UP_QUEUE (new 23ai)

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

TBD