Oracle | DBMS_TRANSFORM

Oracle DBMS_TRANSFORM_EXIMP 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 Advanced Queuing Transformation Export and Import Related Utilities

AUTHID CURRENT_USER

Dependencies

AQ$_BND_ARRAY	DBMS_ASSERT	DBMS_TRANSFORM_EXIMP_INTERNAL
DBMS_AQADM_INV	DBMS_STANDARD	DBMS_TRANSFORM_INTERNAL
DBMS_AQADM_SYS	DBMS_SYSTEM	PLITBLM

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to PUBLIC, SYSTEM, and the EXECUTE_CATALOG_ROLE. EXP_FULL_DATABASE, and IMP_FULL_DATABASE roles

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

Subprograms

IMPORT_TRANSFORMATION	INSTANCE_INFO_EXP	SCHEMA_INFO_EXP
IMPORT_TRANS_ATTR

IMPORT_TRANSFORMATION

Undocumented dbms_transformeximp.import_transformation( trans_schema IN VARCHAR2, trans_name IN VARCHAR2, from_schema IN VARCHAR2, from_type IN VARCHAR2, to_schema IN VARCHAR2, to_type IN VARCHAR2);

TBD

IMPORT_TRANS_ATTR

Undocumented dbms_transformeximp.import_trans_attr( trans_schema IN VARCHAR2, trans_name IN VARCHAR2, attr_no IN VARCHAR2, sql_expression IN VARCHAR2);

TBD

INSTANCE_INFO_EXP

Undocumented dbms_transformeximp.instance_info_exp( name IN VARCHAR2, schema IN VARCHAR2, prepost IN BINARY_INTEGER, isdba IN BINARY_INTEGER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

DECLARE

       nblock PLS_INTEGER;

       retVal dbms_id;

      BEGIN

        retVal := dbms_transform_eximp.instance_info_exp('SERVERS', 
      'C##UWCLASS', 8192, 1, '23.2', nblock);

        dbms_output.put_line(TO_CHAR(nblock));

      END;

      /

      *

      ORA-00904: "TRANS_NAME": invalid identifier

SCHEMA_INFO_EXP

Undocumented dbms_transformeximp.schema_info_exp( schema IN VARCHAR2, prepost IN BINARY_INTEGER, isdba IN BINARY_INTEGER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

DECLARE

       retVal VARCHAR2(60);

       nblk BINARY_INTEGER;

      BEGIN

        retVal := dbms_transform_eximp.schema_info_exp('C##UWCLASS', 0, 1, '23.2', nblk);

        dbms_output.put_line('retVal: ' || retVal);

        dbms_output.put_line('New Block: ' || TO_CHAR(nblk));

      END;

      /

      retVal:

      New Block:

      

      PL/SQL procedure successfully completed.