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

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"