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 is now availble. If you haven't you downloaded already: Why?

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