Oracle DBMS_AW
Version 11.2.0.3
 
General Information
Description This package is the interface to the Express server routines
-- interp - This function interprets an OLAP DML command and returns the output as a character LOB.
-- execute - This procedure executes an OLAP DML command and uses dbms_output to print the results.
Source {ORACLE_HOME}/rdbms/admin/dbmsaw.sql
First Available 10.2.0.1
Constants
Name Data Type Value
NO_HIER BINARY_INTEGER 0
MEASURE BINARY_INTEGER 1
HIER_PARENTCHILD BINARY_INTEGER 2
HIER_LEVELS BINARY_INTEGER 3
HIER_SNOWFLAKE BINARY_INTEGER 4
 
PARTBY_DEFAULT BINARY_INTEGER 0
PARTBY_NONE BINARY_INTEGER 1
PARTBY_FORCE BINARY_INTEGER 2147483647
 
ADVICE_DEFAULT BINARY_INTEGER 0
ADVICE_FAST BINARY_INTEGER 1
ADVICE_FULL BINARY_INTEGER 2
ADVICE_NOSAMPLE BINARY_INTEGER 3
 
EIFIMP_DATA BINARY_INTEGER 1
EIFIMP_DEFINES BINARY_INTEGER 2
EIFIMP_DFNS BINARY_INTEGER EIFIMP_DEFINES
EIFIMP_DATADEFINES BINARY_INTEGER 3
EIFIMP_DATADFNS BINARY_INTEGER EIFIMP_DATADEFINES
 
en_tbs_error NUMBER -20001
bad_compat_error NUMBER -20002
aw_changed_error NUMBER -20003
awname_null_error NUMBER -20004
has_schema_error NUMBER -20005
bad_snowflake_error NUMBER -20006
Dependencies
ALL_AW_PROP DBMS_AW$_DIMENSION_SOURCE_T
ALL_PART_TABLES DBMS_AWM
ALL_TABLES DBMS_AW_EXP
APS_VALIDATE DBMS_AW_LIB
AW$ DBMS_CUBE
AW_REN_PROC DBMS_CUBE_EXP
AW_TRUNC_PROC DBMS_CUBE_LOG
CWM2_OLAP_AW_AWUTIL DBMS_LOB
CWM2_OLAP_OLAPAPI_ENABLE DBMS_OUTPUT
DBA_AW_PROP DBMS_STATS
DBA_TABLESPACES PLITBLM
DBMS_ASSERT USER_AW_PROP
DBMS_AW$_COLUMNLIST_T V$OPTION
DBMS_AW$_DIMENSION_SOURCES_T V$PARAMETER
Exceptions
Number Name
  AWNAME_IS_NULL
Defined Data Types CREATE OR REPLACE TYPE sys.dbms_aw$_columnlist_t
AS TABLE OF VARCHAR2(100)
/

CREATE OR REPLACE TYPE sys.dbms_aw$_dimension_source_t AS OBJECT (
dimname     VARCHAR2(100),
columnname  VARCHAR2(100),
sourcevalue VARCHAR2(32767),
dimtype     NUMBER(3,0),
hiercols    dbms_aw$_columnlist_t,
partby      NUMBER(10,0))
/

CREATE OR REPLACE TYPE dbms_aw$_dimension_sources_t
AS TABLE OF dbms_aw$_dimension_source_t
/

TYPE eif_t IS TABLE OF BLOB NOT NULL;

TYPE eif_objlist_t IS TABLE OF VARCHAR2(100);

TYPE loblineiter_t IS RECORD (
mylob   CLOB,
loc     NUMBER,
clength NUMBER,
cmax    NUMBER,
linemax NUMBER);
/
Security Model execute is granted to PUBLIC
Subprograms
ADD_DIMENSION_SOURCE DISABLE_ACCESS_TRACKING INTERPCLOB
ADVISE_CUBE EIF_BLOB_IN INTERP_SILENT
ADVISE_DIMENSIONALITY EIF_BLOB_OUT MOVE_AWMETA
ADVISE_PARTITIONING_DIMENSION EIF_DELETE OLAP_ACTIVE
ADVISE_PARTITIONING_LEVEL EIF_IN OLAP_ON
ADVISE_REL EIF_OUT OLAP_RUNNING
ADVISE_SPARSITY ENABLE_ACCESS_TRACKING OLAP_TYPE
AW_ATTACH EVAL_NUMBER PRINTLOG
AW_COPY EVAL_TEXT PROP_CLOB
AW_CREATE EXECUTE PROP_LEN
AW_DELETE GATHER_STATS PROP_VAL
AW_DETACH GETLOG RUN
AW_RENAME GET_OBJ_PROTECT SHUTDOWN
AW_TABLESPACE IN_AW_CLEANUP SPARSITY_ADVICE_TABLE
AW_UPDATE INFILE STARTUP
CLEAN_ACCESS_TRACKING INITDRIVER TOGGLEDBCREATE
CONVERT INTERP  
 
ADD_DIMENSION_SOURCE
Undocumented dbms_aw.add_dimension_source(dimname IN VARCHAR2,
colname  IN     VARCHAR2,
sources  IN OUT dbms_aw$_dimension_sources_t,
srcval   IN     VARCHAR2              DEFAULT NULL,
dimtype  IN     NUMBER                DEFAULT NO_HIER,
hiercols IN     dbms_aw$_columnlist_t DEFAULT NULL,
partby   IN     NUMBER                DEFAULT PARTBY_DEFAULT);
TBD
 
ADVISE_CUBE
Undocumented dbms_aw.advise_cube(
aggmap     IN VARCHAR2,
pct        IN BINARY_INTEGER DEFAULT 20,
compressed IN BOOLEAN        DEFAULT FALSE);
TBD
 
ADVISE_DIMENSIONALITY
Undocumented

Overload 1		 dbms_aw.advise_dimensionality(
cubename   IN  VARCHAR2,
sparsedfn  OUT VARCHAR2,
sparsename IN  VARCHAR2 DEFAULT NULL,
partnum    IN  NUMBER   DEFAULT 1,
advtable   IN  VARCHAR2 DEFAULT NULL)
RETURN VARCHAR2;
TBD
Overload 2 dbms_aw.advise_dimensionality(
output     OUT NOCOPY CLOB,
cubename   IN         VARCHAR2,
sparsename IN         VARCHAR2 DEFAULT NULL,
dtype      IN         VARCHAR2 DEFAULT 'NUMBER',
advtable   IN         VARCHAR2 DEFAULT NULL);
TBD
 
ADVISE_PARTITIONING_DIMENSION
Undocumented dbms_aw.advise_partitioning_dimension(
cubename   IN VARCHAR2,
dimsources IN dbms_aw$_dimension_sources_t,
advtable   IN VARCHAR2 DEFAULT NULL)
RETURN VARCHAR2;
TBD
 
ADVISE_PARTITIONING_LEVEL
Undocumented dbms_aw.advise_partitioning_level(
cubename   IN VARCHAR2,
dimsources IN dbms_aw$_dimension_sources_t,
advtable   IN VARCHAR2 DEFAULT NULL)
RETURN VARCHAR2;
TBD
 
ADVISE_REL
Undocumented dbms_aw.advise_rel(
relname    IN VARCHAR2,
valueset   IN VARCHAR2,
pct        IN BINARY_INTEGER DEFAULT 20,
compressed IN BOOLEAN DEFAULT FALSE);
TBD
 
ADVISE_SPARSITY
Undocumented dbms_aw.advise_sparsity(
fact       IN VARCHAR2,
cubename   IN VARCHAR2,
dimsources IN dbms_aw$_dimension_sources_t,
advmode    IN BINARY_INTEGER DEFAULT ADVICE_DEFAULT,
partby     IN BINARY_INTEGER DEFAULT PARTBY_DEFAULT,
advtable   IN VARCHAR2       DEFAULT NULL);
TBD
 
AW_ATTACH
Undocumented

Overload 1		 dbms_aw.aw_attach(
name     IN VARCHAR2,
forwrite IN BOOLEAN  DEFAULT FALSE,
createaw IN BOOLEAN  DEFAULT FALSE,
attargs  IN VARCHAR2 DEFAULT NULL,
tbspace  IN VARCHAR2 DEFAULT NULL);
TBD
Overload 2 dbms_aw.aw_attach(
schema   IN VARCHAR2,
name     IN VARCHAR2,
forwrite IN BOOLEAN  DEFAULT FALSE,
createaw IN BOOLEAN  DEFAULT FALSE,
attargs  IN VARCHAR2 DEFAULT NULL,
tbspace  IN VARCHAR2 DEFAULT NULL);
TBD
 
AW_COPY
Undocumented

Overload 1		 dbms_aw.aw_copy(
oldname       IN VARCHAR2,
newname       IN VARCHAR2,
newtablespace IN VARCHAR2 DEFAULT NULL,
partnum       IN NUMBER   DEFAULT 8);
TBD
Overload 2 dbms_aw.aw_copy(
oldschema     IN VARCHAR2,
oldname       IN VARCHAR2,
newname       IN VARCHAR2,
newtablespace IN VARCHAR2 DEFAULT NULL,
partnum       IN NUMBER   DEFAULT 8);
TBD
 
AW_CREATE
Undocumented

Overload 1		 dbms_aw.aw_create(
name    IN VARCHAR2,
tbspace IN VARCHAR2 DEFAULT NULL,
partnum IN NUMBER   DEFAULT 8);
TBD
Overload 2 dbms_aw.aw_create(
schema  IN VARCHAR2,
name    IN VARCHAR2,
tbspace IN VARCHAR2 DEFAULT NULL);
TBD
 
AW_DELETE
Undocumented

Overload 1		 dbms_aw.aw_delete(name IN VARCHAR2);
TBD
Overload 2 dbms_aw.aw_delete(schema IN VARCHAR2, name IN VARCHAR2);
TBD
 
AW_DETACH
Undocumented

Overload 1		 dbms_aw.aw_detach(name IN VARCHAR2);
TBD
Overload 2 dbms_aw.aw_detach(schema IN VARCHAR2, name IN VARCHAR2);
TBD
 
AW_RENAME
Undocumented dbms_aw.aw_rename(inname IN VARCHAR2, outname IN VARCHAR2);
TBD
 
AW_TABLESPACE
Undocumented

Overload 1		 dbms_aw.aw_tablespace(schema IN VARCHAR2, name IN VARCHAR2) RETURN VARCHAR2;
TBD
Overload 2 dbms_aw.aw_tablespace(name IN VARCHAR2) RETURN VARCHAR2;
TBD
 
AW_UPDATE
Undocumented

Overload 1		 dbms_aw.aw_update(name IN VARCHAR2 DEFAULT NULL);
TBD
Overload 2 dbms_aw.aw_update(schema IN VARCHAR2, name IN VARCHAR2);
TBD
 
CLEAN_ACCESS_TRACKING
Undocumented dbms_aw.clean_access_tracking(objname IN VARCHAR2);
TBD
 
CONVERT
Undocumented

Overload 1		 dbms_aw.convert(awname IN VARCHAR2);
TBD
Overload 2 dbms_aw.convert(
oldname       IN VARCHAR2,
newname       IN VARCHAR2,
newtablespace IN VARCHAR2 DEFAULT NULL);
TBD
 
DISABLE_ACCESS_TRACKING
Undocumented dbms_aw.disable_access_tracking(objname IN VARCHAR2);
TBD
 
EIF_BLOB_IN (new 11.2.0.1 parameter)
Undocumented

Overload 1		 dbms_aw.eif_blob_in(
name     IN VARCHAR2,
implob   IN BLOB,
datadfns IN BINARY_INTEGER DEFAULT EIFIMP_DATA,
objlist  IN eif_objlist_t  DEFAULT NULL
api      IN BOOLEAN        DEFAULT TRUE);
TBD
Overload 2 dbms_aw.eif_blob_in(
schema   IN VARCHAR2,
name     IN VARCHAR2,
implob   IN BLOB,
datadfns IN BINARY_INTEGER DEFAULT EIFIMP_DATA,
objlist  IN eif_objlist_t  DEFAULT NULL,
api      IN BOOLEAN        DEFAULT TRUE);
TBD
 
EIF_BLOB_OUT (new 11.2.0.1 parameter)
Undocumented

Overload 1		 dbms_aw.eif_blob_out(
name    IN VARCHAR2,
objlist IN eif_objlist_t DEFAULT NULL,
api     IN BOOLEAN       DEFAULT TRUE)
RETURN BLOB;
TBD
Overload 2 dbms_aw.eif_blob_out(
schema  IN VARCHAR2,
name    IN VARCHAR2,
objlist IN eif_objlist_t DEFAULT NULL,
api     IN BOOLEAN       DEFAULT TRUE)
RETURN BLOB;
TBD
 
EIF_DELETE
Undocumented dbms_aw.eif_delete(eif IN OUT eif_t);
TBD
 
EIF_IN
Undocumented

Overload 1		 dbms_aw.eif_in(
name     IN VARCHAR2,
impeif   IN eif_t,
datadfns IN BINARY_INTEGER DEFAULT EIFIMP_DATA,
objlist  IN eif_objlist_t  DEFAULT NULL);
TBD
Overload 2 dbms_aw.eif_in(
schema   IN VARCHAR2,
name     IN VARCHAR2,
impeif   IN eif_t,
datadfns IN BINARY_INTEGER DEFAULT EIFIMP_DATA,
objlist  IN eif_objlist_t  DEFAULT NULL);
TBD
 
EIF_OUT
Undocumented

Overload 1		 dbms_aw.eif_out(
name    IN  VARCHAR2,
expeif  OUT eif_t,
objlist IN  eif_objlist_t DEFAULT NULL);
TBD
Overload 2 dbms_aw.eif_out(
schema  IN  VARCHAR2,
name    IN  VARCHAR2,
expeif  OUT eif_t,
objlist IN  eif_objlist_t DEFAULT NULL);
TBD
 
ENABLE_ACCESS_TRACKING
Undocumented dbms_aw.enable_access_tracking(objname IN VARCHAR2);
TBD
 
EVAL_NUMBER
Undocumented dbms_aw.eval_number(cmd IN STRING) RETURN NUMBER;
TBD
 
EVAL_TEXT
Undocumented dbms_aw.eval_text(cmd IN STRING) RETURN VARCHAR2;
TBD
 
EXECUTE
Undocumented dbms_aw.execute(cmd IN STRING);
TBD
 
GATHER_STATS
Undocumented dbms_aw.gather_stats;
exec dbms_aw.gather_stats;
 
GETLOG
Undocumented dbms_aw.getlog RETURN CLOB;
SELECT dbms_aw.getlog
FROM dual;
 
IN_AW_CLEANUP (new 11.2.0.3)
Undocumented dbms_aw.in_aw_cleanup RETURN BOOLEAN;
set serveroutput on

BEGIN
  IF dbms_aw.in_aw_cleanup THEN
    dbms_output.put_line('TRUE');
  ELSE
    dbms_output.put_line('FALSE');
  END IF;
END;
/
 
INFILE
Undocumented dbms_aw.infile(ifilename IN STRING);
TBD
 
INITDRIVER
Undocumented dbms_aw.initdriver;
exec dbms_aw.initdriver;
 
INTERP
Undocumented dbms_aw.interp(cmd IN string) RETURN CLOB;
TBD
 
INTERPCLOB
Undocumented dbms_aw.interpclob(cmd_clob IN CLOB) RETURN CLOB;
TBD
 
INTERP_SILENT
Undocumented dbms_aw.interp_silent(cmd IN STRING);
TBD
 
MOVE_AWMETA
Undocumented dbms_aw.move_awmeta(dest_tbs IN VARCHAR2);
TBD
 
OLAP_ACTIVE
Returns TRUE if OLAP services are active: Otherwise FALSE. dbms_aw.olap_active RETURN BOOLEAN;
set serveroutput on

BEGIN
  IF dbms_aw.olap_active THEN
    dbms_output.put_line('TRUE');
  ELSE
    dbms_output.put_line('FALSE');
  END IF;
END;
/
 
OLAP_ON
Returns TRUE if OLAP services are enabled: Otherwise FALSE. dbms_aw.olap_on RETURN BOOLEAN;
set serveroutput on

BEGIN
  IF dbms_aw.olap_on THEN
    dbms_output.put_line('TRUE');
  ELSE
    dbms_output.put_line('FALSE');
  END IF;
END;
/
 
OLAP_RUNNING
Returns TRUE if OLAP services are running: Otherwise FALSE. dbms_aw.olap_running RETURN BOOLEAN;
set serveroutput on

BEGIN
  IF dbms_aw.olap_running THEN
    dbms_output.put_line('TRUE');
  ELSE
    dbms_output.put_line('FALSE');
  END IF;
END;
/
 
OLAP_TYPE
Undocumented dbms_aw.olap_type(otype IN NUMBER) RETURN VARCHAR2;
TBD
 
PRINTLOG
Undocumented dbms_aw.printlog(log_clob IN CLOB);
TBD
 
PROP_CLOB
Undocumented dbms_aw.prop_clob(rid IN ROWID) RETURN CLOB;
TBD
 
PROP_LEN
Undocumented dbms_aw.prop_len(rid IN ROWID) RETURN NUMBER;
TBD
 
PROP_VAL
Undocumented dbms_aw.prop_val(rid IN ROWID) RETURN VARCHAR2;
TBD
 
RUN
Handles output for the user

Overload 1		 dbms_aw.run(cmd IN STRING, silent IN BOOLEAN DEFAULT FALSE);
TBD
Handles output for the user

Overload 2		 dbms_aw.run(cmd IN CLOB, silent IN BOOLEAN DEFAULT FALSE);
TBD
Passes data

Overload 3		 dbms_aw.run(cmd IN STRING, output OUT STRING);
TBD
Passes data

Overload 4		 dbms_aw.run(cmd IN STRING, output IN OUT NOCOPY CLOB);
TBD
Passes data

Overload 5		 dbms_aw.run(cmd IN CLOB, output OUT STRING);
TBD
Passes data

Overload 6		 dbms_aw.run(cmd IN CLOB, output IN OUT NOCOPY CLOB);
TBD
 
SHUTDOWN
Undocumented dbms_aw.shutdown(force IN BOOLEAN DEFAULT FALSE);
exec dbms_aw.shutdown(TRUE);
 
SPARSITY_ADVICE_TABLE
Undocumented dbms_aw.sparsity_advice_table(tblname IN VARCHAR2 DEFAULT NULL);
TBD
 
STARTUP
Undocumented dbms_aw.startup;
exec dbms_aw.startup;
 
TOGGLEDBCREATE
Undocumented dbms_aw.toggledbcreate;
exec dbms_aw.toggledbcreate;
 
Related Topics
DBMS_AW_STATS
Packages
 
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-2013 Daniel A. Morgan All Rights Reserved