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

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