Oracle DBMS_AW_EXP
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 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 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