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
O n-L ine A nalytic P rocessing Support Utilities
AUTHID
CURRENT_USER
Data Types
TYPE rawvec_t IS TABLE OF RAW(31744);
TYPE varchar2vec_t IS TABLE OF VARCHAR2(31744);
Dependencies
ALL_AWS
DBMS_LOB
KUPCC
ALL_OBJECTS
DBMS_OUTPUT
KUPP$PROC
ALL_TABLES
DBMS_STANDARD
PLITBLM
DBA_AWS
DBMS_ZHELP
TABLE_PRIVILEGE_MAP
DBMS_ASSERT
KU$_JOBDESC1020
USER_TABLES
DBMS_AW
KU$_JOBSTATUS1020
UTL_ENCODE
DBMS_AW_LIB
KU$_PARAMVALUE1010
UTL_FILE
DBMS_CUBE_EXP
KU$_PARAMVALUES1010
UTL_RAW
DBMS_DATAPUMP
KU$_STATUS1020
Documented
No
Exceptions
Error Code
Reason
N/A
EIF_LOB_SIZE_OUT_OF_RANGE EXCEPTION;
ORA-20004
INVALID_AW_VERSION CONSTANT NUMBER
ORA-20005
CROSS_PLATFORM_TRANSPORT
ORA-20006
AW_TOO_MANY_OBJECTS
First Available
Not known
Pragma
PRAGMA supplemental_log_data(default, READ_ONLY);
Security Model
Owned by SYS with EXECUTE granted to PUBLIC
Source
{ORACLE_HOME}/rdbms/admin/dbmsawex.sql
Subprograms
ALTER_LOB_SIZE
Undocumented
dbms_aw_exp.alter_lob_size(newsize IN NUMBER);
TBD
IMPORT_BEGIN100
Undocumented
dbms_aw_exp.import_begin100(
schema IN VARCHAR2,
name IN VARCHAR2);
TBD
IMPORT_BEGIN112
Undocumented
dbms_aw_exp.import_begin112(
schema IN VARCHAR2,
name IN VARCHAR2);
TBD
IMPORT_BEGIN120
Undocumented
dbms_aw_exp.import_begin120(
chema IN VARCHAR2,
name IN VARCHAR2);
TBD
IMPORT_BEGIN92
Undocumented
dbms_aw_exp.import_begin92(
schema IN VARCHAR2,
name IN VARCHAR2);
TBD
IMPORT_CALLOUT112
Undocumented
dbms_aw_exp.import_callout112(schema IN VARCHAR2);
TBD
IMPORT_CALLOUT120
Undocumented
dbms_aw_exp.import_callout120(schema IN VARCHAR2);
TBD
IMPORT_CHUNK100
Undocumented
dbms_aw_exp.import_chunk100(
amt IN BINARY_INTEGER,
stream IN VARCHAR2);
TBD
IMPORT_CHUNK112
Undocumented
dbms_aw_exp.import_chunk112(
amt IN BINARY_INTEGER,
stream IN VARCHAR2);
TBD
IMPORT_CHUNK120
Undocumented
dbms_aw_exp.import_chunk120(
amt IN BINARY_INTEGER,
stream IN VARCHAR2);
TBD
IMPORT_CHUNK92
Undocumented
dbms_aw_exp.import_chunk92(
amt IN BINARY_INTEGER,
stream IN VARCHAR2);
TBD
IMPORT_FINISH100
Undocumented
dbms_aw_exp.import_finish100(
schema IN VARCHAR2,
name IN VARCHAR2);
TBD
IMPORT_FINISH112
Undocumented
dbms_aw_exp.import_finish112(
schema IN VARCHAR2,
name IN VARCHAR2);
TBD
IMPORT_FINISH120
Undocumented
dbms_aw_exp.import_finish120(
schema IN VARCHAR2,
name IN VARCHAR2);
TBD
IMPORT_FINISH92
Undocumented
dbms_aw_exp.import_finish92(
schema IN VARCHAR2,
name IN VARCHAR2);
TBD
IMPORT_TABLE_CALLOUT120
Undocumented
dbms_aw_exp.import_table_callout120(
schema IN VARCHAR2,
tabname IN VARCHAR2,
preport IN PLS_INTEGER);
TBD
INSTANCE_CALLOUT_IMP
Undocumented
dbms_aw_exp.instance_callout_imp(
obj_name IN VARCHAR2,
obj_schema IN VARCHAR2,
obj_type IN VARCHAR2,
prepost IN PLS_INTEGER,
action OUT VARCHAR2,
alt_name OUT VARCHAR2);
TBD
INSTANCE_EXTENDED_INFO_EXP
Undocumented
dbms_aw_exp.instance_extended_info_exp(
name IN VARCHAR2,
schema IN VARCHAR2,
namespace IN PLS_INTEGER,
type IN PLS_INTEGER,
prepost IN PLS_INTEGER,
exp_user IN VARCHAR2,
isdba IN PLS_INTEGER,
version IN VARCHAR2,
new_block OUT PLS_INTEGER)
RETURN VARCHAR2;
TBD
LOB_WRITE
Undocumented
Overload 1
dbms_aw_exp.lob_write(
wlob IN OUT NOCOPY BLOB,
pos IN BINARY_INTEGER,
data IN rawvec_t)
RETURN BINARY_INTEGER;
TBD
Overload 2
dbms_aw_exp.lob_write(
wlob IN OUT NOCOPY CLOB CHARACTER SET ANY_CS,
pos IN BINARY_INTEGER,
data IN varchar2vec_t)
RETURN BINARY_INTEGER;
TBD
LOB_WRITE APPEND (new 21c)
Undocumented
Overload 1
dbms_aw_exp.lob_writeappend(
wlob IN OUT NOCOPY BLOB,
data IN rawvec_t)
RETURN BINARY_INTEGER;
TBD
Overload 2
dbms_aw_exp.lob_writeappend(
wlob IN OUT NOCOPY CLOB CHARACTER SET ANY_CS,
data IN varchar2vec_t)
RETURN BINARY_INTEGER;
TBD
SCHEMA_CALLOUT
Undocumented
dbms_aw_exp.schema_callout(
schema IN VARCHAR2,
prepost IN PLS_INTEGER,
isdba IN PLS_INTEGER,
version IN VARCHAR2);
TBD
SCHEMA_INFO_EXP
Undocumented
dbms_aw_exp.schema_info_exp(
schema IN VARCHAR2,
prepost IN PLS_INTEGER,
isdba IN PLS_INTEGER,
version IN VARCHAR2,
new_block OUT PLS_INTEGER)
RETURN VARCHAR2;
TBD
TRANSPORTING
Undocumented
dbms_aw_exp.transporting RETURN BOOLEAN;
BEGIN
IF dbms_aw_exp.transporting THEN
dbms_output.put_line('T');
ELSE
dbms_output.put_line('F');
END IF;
END;
/
F
PL/SQL procedure successfully completed.
TRANS_BEGIN102
Undocumented
dbms_aw_exp.trans_begin102(
awname IN VARCHAR2,
schema IN VARCHAR2,
namespace IN PLS_INTEGER,
type IN PLS_INTEGER);
TBD
TRANS_CHUNK102
Transportable tablespace support
dbms_aw_exp.trans_chunk102(
amt IN BINARY_INTEGER,
stream IN VARCHAR2);
TBD
TRANS_FINISH102
Transportable tablespace support
dbms_aw_exp.trans_finish102(
awname IN VARCHAR2,
schema IN VARCHAR2,
namespace IN PLS_INTEGER,
type IN PLS_INTEGER);
TBD
TRANS_FINISH112
Transportable tablespace support
dbms_aw_exp.trans_finish112(
awname IN VARCHAR2,
schema IN VARCHAR2,
namespace IN PLS_INTEGER,
type IN PLS_INTEGER,
prepost IN PLS_INTEGER);
TBD
TRANS_FINISH120
Transportable tablespace support
dbms_aw_exp.trans_finish120(
awname IN VARCHAR2,
schema IN VARCHAR2,
namespace IN PLS_INTEGER,
type IN PLS_INTEGER,
prepost IN PLS_INTEGER);
TBD
TRANS_FINISH122
Transportable tablespace support
dbms_aw_exp.trans_finish122(
awname IN VARCHAR2,
schema IN VARCHAR2,
namespace IN PLS_INTEGER,
type IN PLS_INTEGER,
prepost IN PLS_INTEGER);
TBD