Oraclue

Oracle internals, debugging and undocumented features

DBMS_DUMA_INTERNAL

Accidentally 🙂 found this  package  in Oracle version 11.2.0.1 .No documentation available but that’s the case with internals so be careful with this ( use in test database ).

cd $ORACLE_HOME/rdbms/admin

SQL> @prvtdumi.plb

Library created.

Package created.

No errors.

Package body created.

No errors.

1* select object_name,object_type from dba_objects where object_name like ‘%DUMA%’
SQL> /

OBJECT_NAME                                   OBJECT_TYPE
——————————————— ——————-
DUMA_LIB                                      LIBRARY
DBMS_DUMA_INTERNAL                            PACKAGE
DBMS_DUMA_INTERNAL                            PACKAGE BODY

SQL> desc dbms_duma_internal
PROCEDURE CONVERT_LONG
Argument Name                  Type                    In/Out Default?
—————————— ———————– —— ——–
TARGET_TABLE_ID                NUMBER                  IN
SOURCE_TABLE_ID                NUMBER                  IN
BUFFER_SIZE                    NUMBER                  IN     DEFAULT
DDBCS_ID                       NUMBER                  IN     DEFAULT
ROWS_TO_COMMIT                 NUMBER                  IN     DEFAULT
START_ROWID                    ROWID                   IN     DEFAULT
END_ROWID                      ROWID                   IN     DEFAULT
FLAGS                          VARCHAR2                IN     DEFAULT
FUNCTION GET_PROPERTY RETURNS NUMBER
Argument Name                  Type                    In/Out Default?
—————————— ———————– —— ——–
PROPERTY_INDEX                 NUMBER                  IN
FUNCTION READ_LONG_TO_BLOB RETURNS BLOB
Argument Name                  Type                    In/Out Default?
—————————— ———————– —— ——–
OWNER_NAME                     VARCHAR2                IN
TABLE_NAME                     VARCHAR2                IN
COLUMN_NAME                    VARCHAR2                IN
ROW_ID                         ROWID                   IN
BUFFER_SIZE                    NUMBER                  IN     DEFAULT
PROCEDURE SCAN_TABLE
Argument Name                  Type                    In/Out Default?
—————————— ———————– —— ——–
TABLE_ID                       NUMBER                  IN
SCAN_ID                        NUMBER                  IN     DEFAULT
BUFFER_SIZE                    NUMBER                  IN     DEFAULT
DDBCS_ID                       NUMBER                  IN     DEFAULT
START_ROWID                    ROWID                   IN     DEFAULT
END_ROWID                      ROWID                   IN     DEFAULT
FLAGS                          VARCHAR2                IN     DEFAULT
PROCEDURE WRITE_BLOB_TO_LONG
Argument Name                  Type                    In/Out Default?
—————————— ———————– —— ——–
SOURCE_LOB                     BLOB                    IN
OWNER_NAME                     VARCHAR2                IN
TABLE_NAME                     VARCHAR2                IN
COLUMN_NAME                    VARCHAR2                IN
ROW_ID                         ROWID                   IN
BUFFER_SIZE                    NUMBER                  IN     DEFAULT

Advertisements

One response to “DBMS_DUMA_INTERNAL

  1. Kyle Hailey May 30, 2010 at 3:21 pm

    Looks fascinating! Maybe an answer to the ago old question of how to migrate longs

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: