Oracle | DBMS_DUMA

Oracle DBMS_DUMA_INTERNAL 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 Database Unicode Migration Assistant. This package was created to support the Database Migration Assistant GUI.

AUTHID CURRENT_USER

Data Types TYPE dukl_detect_columns IS ... TYPE dukl_detect_result_table IS TABLE OF ... TYPE dukl_detect_rowids IS ... TYPE dukl_index_key_size_info_table IS ...

Dependencies

DUMA_LIB

PLITBLM

Documented Yes, but not in the Packages and Types documentation.

https://www.oracle.com/database/technologies/dmu-gettingstarted.html

First Available 12.1

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtdumi.plb

SQL> @?/rdbms/admin/prvtdumi.plb

      

      Library created.

      

      SP2-0808: Package created with compilation warnings

      

      Errors for PACKAGE SYS.DBMS_DUMA_INTERNAL:

      

      LINE/COL ERROR

      ------------------------------------------------------------------------

      27/3 PLW-06010: keyword "LANGUAGE" used as a defined name

      

      SP2-0810: Package Body created with compilation warnings

      

      Errors for PACKAGE BODY SYS.DBMS_DUMA_INTERNAL:

      

      35/14 PLW-07203: parameter 'RESULT_TABLE' may benefit from use of the

      NOCOPY compiler hint

      

      87/3 PLW-07206: analysis suggests that the assignment to

      'RESULT_TABLE' may be unnecessary

      

      116/3 PLW-07206: analysis suggests that the assignment to

      'RESULT_TABLE' may be unnecessary

      

      145/3 PLW-07206: analysis suggests that the assignment to 

      'RESULT_TABLE' may be unnecessary

Subprograms

ALTER_DATABASE_CHARSET	CONVERT_LONG	READ_LONG_TO_BLOB
CHECK_ALL_INDEXES	DETECT_LANGUAGE_ENCODING	SCAN_TABLE
CHECK_INDEXES	GET_PROPERTY	WRITE_BLOB_TO_LONG
CONVERT_AUD_UNIFIED

ALTER_DATABASE_CHARSET (new 23ai)

Undocumented dbms_duma_internal.alter_database_charset(force_complete IN BOOLEAN);

exec dbms_duma_internal.alter_database_charset(FALSE);

           *

      ORA-62013: OCI error status -2, source line 1706

      ORA-12721: operation annot exeucte when other sessions are active

CHECK_ALL_INDEXES (new 23ai)

Undocumented dbms_duma_internal.check_all_indexes( table_id IN NUMBER, flags IN VARCHAR2); RETURN NUMBER;

TBD

CHECK_INDEXES (new 23ai)

Undocumented dbms_duma_internal.check_indexes( table_id IN NUMBER, intcol_id IN NUMBER, new_length IN NUMBER, flags IN VARCHAR2); RETURN sys.dbms_duma_internal.dukl_index_key_size_info_table;

TBD

CONVERT_AUD_UNIFIED (new 23ai)

Appears intended to convert legacy auditing to unified auditing dbms_duma_internal.convert_aud_unified;

exec dbms_duma_internal.convert_aud_unified;

           *

      ORA-62014: internal error, arguments: [DUM$DATABASE not found], [327], [], [], [], []

      ORA-00942: table or view does not exist

CONVERT_LONG

Undocumented dbms_duma_internal.convert_long( target_table_id IN NUMBER, source_table_id IN NUMBER, buffer_size IN NUMBER, ddbcs_id IN NUMBER, rows_to_commit IN NUMBER, start_rowid IN ROWID, end_rowid IN ROWID, flags IN VARCHAR2);

TBD

DETECT_LANGUAGE_ENCODING

Undocumented

Overload 1 dbms_duma_internal.detect_language_encoding( obj_id IN NUMBER, list_columns IN sys.dbms_duma_internal.dukl_detect_columns, flags IN VARCHAR2 detect_profile IN NUMBER, buffer_size IN NUMBER, num_results IN NUMBER, sampling_size IN NUMBER) RETURN sys.dbms_duma_internal.dukl_detect_result_table;

TBD

Undocumented

Overload 2 dbms_duma_internal.detect_language_encoding(obj_id IN NUMBER list_columns IN sys.dbms_duma_internal.dukl_detect_columns, list_rowids IN sys.dbms_duma_internal.dukl_detect_rowids, detect_profile IN NUMBER, buffer_size IN NUMBER, num_results IN NUMBER, sampling_size IN NUMBER) RETURN sys.dbms_duma_internal.dukl_detect_result_table;

TBD

Undocumented

Overload 3 dbms_duma_internal.detect_language_encoding( obj_id IN NUMBER, list_columns IN sys.dbms_duma_internal.dukl_detect_columns, start_rowid IN ROWID, end_rowid IN ROWID, detect_profile IN NUMBER, buffer_size IN NUMBER, num_results IN NUMBER, sampling_size IN NUMBER) RETURN sys.dbms_duma_internal.dukl_detect_result_table;

TBD

GET_PROPERTY

Undocumented dbms_duma_internal.get_property(property_index IN NUMBER) RETURN NUMBER;

SELECT dbms_duma_internal.get_property(1);

      

      DBMS_DUMA_INTERNAL.GET_PROPERTY(1)

      ----------------------------------

                                       5

      

      SELECT dbms_duma_internal.get_property(2);

             *

      ORA-62010: invalid argument: PROPERTY_INDEX

READ_LONG_TO_BLOB

Undocumented dbms_duma_internal.read_long_to_blob( owner_name IN VARCHAR2, table_name IN VARCHAR2, column_name IN VARCHAR2, row_id IN ROWID, buffer_size IN NUMBER) RETURN BLOB;

DECLARE

       cVar CLOB;

      BEGIN

        cVar := dbms_metadata_util.long2clob(120, 'TRIGGER$', 'ACTION#', 'AAAAEoAABAAAAopAAA');

      END;

      /

      META:00:20:50.696: exception from 'SELECT ACTION# FROM TRIGGER$ WHERE ROWID = :1' for rowid value AAAAEoAABAAAAopAAA : ORA-31600: invalid input value TRIGGER$ for parameter TAB in

      function UTL_XML.LONG2CLOB

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105

      ORA-06512: at "SYS.UTL_XML", line 195

      ----- PL/SQL Call Stack -----

      object line object

      handle

      number name

      0x1283e3910 767 package body SYS.DBMS_METADATA_UTIL.LONG2CLOB

      0x1238f5d88 4 anonymous block

      

      PL/SQL procedure successfully completed.

      

      DECLARE

       bVal BLOB;

      BEGIN

        bVal := dbms_duma_internal.read_long_to_blob('SYS', 'TRIGGER$', 'ACTION#', 'AAAAEoAABAAAAopAAA');

      END;

      /

      

      PL/SQL procedure successfully completed.

SCAN_TABLE

Undocumented dbms_duma_internal.scan_table( table_id IN NUMBER, scan_id IN NUMBER, buffer_size IN NUMBER, ddbcs_id IN NUMBER, start_rowid IN ROWID, end_rowid IN ROWID, flags IN VARCHAR2);

TBD

WRITE_BLOB_TO_LONG

Undocumented dbms_duma_internal.write_blob_to_long( source_lob IN BLOB, owner_name IN VARCHAR2, table_name IN VARCHAR2, column_name IN VARCHAR2, row_id IN ROWID, buffer_size IN NUMBER);

TBD