Oracle | DBMS_TRANSFORM

Oracle DBMS_TRANSFORM_EXIMP Version 21c

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 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, '21.0', nblock);

        dbms_output.put_line(TO_CHAR(nblock));

      END;

      /

      DECLARE

      *

      ERROR at line 1:

      ORA-00904: "TRANS_NAME": invalid identifier

      ORA-06512: at "SYS.DBMS_TRANSFORM_EXIMP", line 213

      ORA-06512: at line 5

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, '21.0', 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.