Oracle | DBMS_ROW_CHANGE

Oracle DBMS_ROW_CHANGE_TRACKING 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 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 23.1 Beta

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

Undocumented dbms_row_change_tracking.consume( uname IN dbms_quoted_id, tname IN dbms_quoted_id, as_of_scn IN NUMBER); PRAGMA SUPPLEMENTAL_LOG_DATA(get_rows, READ_ONLY);

TBD

GET_ROWID_RANGES (new 23c)

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; PRAGMA SUPPLEMENTAL_LOG_DATA(get_rows, READ_ONLY);

TBD

GET_ROWS (new 23c)

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; PRAGMA SUPPLEMENTAL_LOG_DATA(get_rows, READ_ONLY);

TBD