Oracle | DBMS_ROW_CHANGE

Oracle DBMS_ROW_CHANGE_TRACKING 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 CURRENT_USER

Data Types TYPE change_rec IS RECORD ( change_tracking$rowid VARCHAR2(18), change_tracking$opcode VARCHAR2(3), change_tracking$object_id INTEGER); TYPE change_tbl IS TABLE OF change_rec; TYPE zone_change_rec IS RECORD ( change_tracking$rowid_lo VARCHAR2(18), change_tracking$rowid_hi VARCHAR2(18), change_tracking$$opcode VARCHAR2(3), change_tracking$object_id INTEGER); TYPE zone_change_tbl IS TABLE OF zone_change_rec; -- use the link to the STANDARD package, at page bottom, -- for the definition of DBMS_QUOTED_ID

Dependencies

ALL_OBJECTS	DBMS_ROW_CHANGE_TRACKING_INT
ALL_TABLES	DBMS_ROW_CHANGE_TRACKING_LIB
DBMS_ASSERT	DBMS_STANDARD

Documented No

First Available 23ai

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE);

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

Source {ORACLE_HOME}/rdbms/admin/dbmschgtrk.sql
{ORACLE_HOME}/rdbms/admin/prvtchgtrk.plb

Subprograms

CONSUME	GET_ROWID_RANGES	GET_ROWS
GET_ALL_ROWID_RANGES

CONSUME (new 23ai)

Undocumented dbms_row_change_tracking.consume( uname IN dbms_quoted_id, tname IN dbms_quoted_id, as_of_scn IN NUMBER);

TBD

GET_ALL_ROWID_RANGES (new 23ai)

Undocumented dbms_row_change_tracking.get_all_rowid_ranges( uname IN dbms_quoted_id, tname IN dbms_quoted_id, as_of_scn IN NUMBER, blocks_per_range IN NUMBER DEFAULT 1024) RETURN zone_change_tbl pipelined;

TBD

GET_ROWID_RANGES (new 23ai)

Undocumented dbms_row_change_tracking.get_rowid_ranges( uname IN dbms_quoted_id, tname IN dbms_quoted_id, as_of_scn IN NUMBER, blocks_per_range IN NUMBER DEFAULT 1024) RETURN zone_change_tbl PIPELINED;

TBD

GET_ROWS (new 23ai)

Undocumented dbms_row_change_tracking.get_rows( uname IN dbms_quoted_id, tname IN dbms_quoted_id, as_of_scn IN NUMBER) RETURN change_tbl PIPELINED;

TBD