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
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);
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
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;