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
Looks fascinating! Maybe an answer to the ago old question of how to migrate longs