| 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 |
|
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; |
