Oracle | DBMS_DUMA

Oracle DBMS_DUMA_INTERNAL 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 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 23c)

Undocumented dbms_duma_internal.alter_database_charset(force_complete IN BOOLEAN);

exec dbms_duma_internal.alter_database_charset(FALSE);

      *

      ERROR at line 1:

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

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

      ORA-06512: at "SYS.DBMS_DUMA_INTERNAL", line 402

      ORA-06512: at "SYS.DBMS_DUMA_INTERNAL", line 416

      ORA-06512: at line 1

CHECK_ALL_INDEXES (new 23c)

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

TBD

CHECK_INDEXES (new 23c)

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 23c)

Appears intended to convert legacy auditing to unified auditing but in 23.2 only generates an exception dbms_duma_internal.convert_aud_unified;

exec dbms_duma_internal.convert_aud_unified;

      *

      ERROR at line 1:

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

      ORA-00942: table or view does not exist

      ORA-06512: at "SYS.DBMS_DUMA_INTERNAL", line 422

      ORA-06512: at "SYS.DBMS_DUMA_INTERNAL", line 436

      ORA-06512: at line 1

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)

      FROM dual;

      

      DBMS_DUMA_INTERNAL.GET_PROPERTY(1)

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

                                       5

      

      SELECT dbms_duma_internal.get_property(2)

      FROM dual;

      SELECT dbms_duma_internal.get_property(2)

             *

      ERROR at line 1:

      ORA-62010: invalid argument: PROPERTY_INDEX

      ORA-06512: at "SYS.DBMS_DUMA_INTERNAL", line 310

      ORA-06512: at "SYS.DBMS_DUMA_INTERNAL", line 325

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