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

Purpose Undocumented

AUTHID DEFINER

Dependencies 2

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