Oracle DBMS_AW_EXP
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 On-Line Analytic Processing 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_WRITEAPPEND (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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_AW
DBMS_AW_INTERNAL
DBMS_AW_STATS
DBMS_AW_XML
What's New In 21c
What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx