Oracle | DBMS_AW

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	IMPORT_CHUNK92	SCHEMA_CALLOUT
IMPORT_BEGIN100	IMPORT_FINISH100	SCHEMA_INFO_EXP
IMPORT_BEGIN112	IMPORT_FINISH112	TRANSPORTING
IMPORT_BEGIN120	IMPORT_FINISH120	TRANS_BEGIN102
IMPORT_BEGIN92	IMPORT_FINISH92	TRANS_CHUNK102
IMPORT_CALLOUT112	IMPORT_TABLE_CALLOUT120	TRANS_FINISH102
IMPORT_CALLOUT120	INSTANCE_CALLOUT_IMP	TRANS_FINISH112
IMPORT_CHUNK100	INSTANCE_EXTENDED_INFO_EXP	TRANS_FINISH120
IMPORT_CHUNK112	LOB_WRITE	TRANS_FINISH122
IMPORT_CHUNK120	LOB_WRITEAPPEND

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