CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_AW

Version 11.1
 
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
 
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_EXP
AW_TRUNC_PROC DBMS_LOB
CWM2_OLAP_AW_AWUTIL DBMS_OUTPUT
CWM2_OLAP_OLAPAPI_ENABLE DBMS_STATS
DBA_AW_PROP PLITBLM
DBA_TABLESPACES USER_AW_PROP
DBMS_ASSERT USER_TABLES
DBMS_AW$_COLUMNLIST_T V$OPTION
DBMS_AW$_DIMENSION_SOURCES_T V$PARAMETER
Exceptions

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
 
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 (new 11g)

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 (new 11g)

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 (new 11g)

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 (new 11g)

Undocumented
dbms_aw.disable_access_tracking(objname IN VARCHAR2);
TBD
 
EIF_BLOB_IN
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);
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);
TBD
 
EIF_BLOB_OUT
Undocumented

Overload 1
dbms_aw.eif_blob_out(
name    IN VARCHAR2,
objlist IN eif_objlist_t DEFAULT NULL)
RETURN BLOB;
TBD

Overload 2
dbms_aw.eif_blob_out(
schema  IN VARCHAR2,
name    IN VARCHAR2,
objlist IN eif_objlist_t DEFAULT NULL)
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 (new 11g)

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 (new 11g)
Undocumented dbms_aw.gather_stats;
exec dbms_aw.gather_stats;
 
GETLOG

Undocumented
dbms_aw.getlog return clob;
SELECT dbms_aw.getlog
FROM dual;
 
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 (new 11g)

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
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [113 users online]    © 2010 psoug.org