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 will be available on generic Linux platforms in January and soon on AIX and Windows

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.