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
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.

Related Topics
Built-in Functions
Built-in Packages
DBMS_TRANSFORM
DBMS_TRANSFORM_EXIMP_INTERNAL
DBMS_TRANSFORM_INTERNAL
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2022 Daniel A. Morgan All Rights Reserved
  DBSecWorx