Oracle | DBMS_ROW_CHANGE_TRACKING

Oracle DBMS_ROW_CHANGE_TRACKING_INT 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

ALL_OBJECTS	DBMS_ROW_CHANGE_TRACKING
ALL_TABLES	DBMS_STANDARD
DBMS_ASSERT	DUAL

Documented No

Exceptions

Error Code	Reason
ORA-20000	Table <schema_name.table_name> does not have row change tracking enabled

First Available 23ai

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/prvschgtrki.plb
{ORACLE_HOME}/rdbms/admin/prvtchgtrki.plb

Subprograms

RESET_JOURNAL

RESET_JOURNAL_STANDBY_ONLY

TRIMDOUBLEQUOTES

RESET_JOURNAL (new 23ai)

Undocumented

The code at right is just a blind attempt to see if the result would provide useful information about this new package: It didn't. The assumption made was UNAME is the user/schema name and TNAME is a heap table. Enabling ROW MOVEMENT did not alter the result. dbms_row_change_tracking_int.reset_journal( uname IN VARCHAR2, tname IN VARCHAR2);

exec dbms_row_change_tracking_int.reset_journal('C##UWCLASS', 'TEST');

           *

      ORA-20000: Table C##UWCLASS.TEST does not have row change tracking enabled

RESET_JOURNAL_STANDBY_ONLY (new 23ai)

Undocumented dbms_row_change_tracking_int.reset_journal_standby_only( uname IN VARCHAR2, tname IN VARCHAR2);

TBD

TRIMDOUBLEQUOTES (new 23ai)

Removes the outer-most leading and trailing double quotes but does not remove any other double quotes dbms_row_change_tracking_int.trimDoubleQuotes( id IN VARCHAR2, isschema IN BOOLEAN) RETURN VARCHAR2;

DECLARE

       sname1 dbms_id := '"UWCLASS"';

       sname2 dbms_id := '"UWC"LASS"';

       sname3 dbms_id := '"UWC"LASS"';

      BEGIN

        dbms_output.put_line(sname1);

        retVal := dbms_row_change_tracking_int.trimDoubleQuotes(sname1);

        dbms_output.put_line(retVal);

      

        dbms_output.put_line(sname2);

        retVal := dbms_row_change_tracking_int.trimDoubleQuotes(sname2);

        dbms_output.put_line(retVal);

      

        dbms_output.put_line(sname3);

        retVal := dbms_row_change_tracking_int.trimDoubleQuotes(sname2);

        dbms_output.put_line(retVal);

      END;

      /

      "UWCLASS"

      UWCLASS

      "UWC"LASS"

      UWC"LASS

      ""UWCLASS""

      "UWCLASS"