Oracle DBMS_TRANSFORM_EXIMP
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx