26
DBMS_OLAP

The DBMS_OLAP package provides a collection of materialized view analysis and advisory functions that are callable from any PL/SQL program.

See Also:
For guidelines on using these functions, please see the Oracle8i Designing and Tuning for Performance manual.

Requirements

DBMS_OLAP utilizes structural statistics (cardinalities of fact tables, dimension tables, and distinct cardinalities of dimension level columns, join key columns, and fact table key columns) and optionally workload statistics on materialized view management events collected by Oracle Trace. The workload tables generated by Oracle Trace, if any, must be stored in the current default schema.

Error Messages

Table 26-1 DBMS_OLAP Error Messages

Error Code	Description
ORA-30476	`PLAN_TABLE` does not exist in the user's schema
ORA-30477	The input `select_clause` is incorrectly specified
ORA-30478	Specified dimension does not exist
ORA-30479	Summary Advisor error\n <QSM message with more details
QSM-00501	Unable to initialize Summary Advisor environment
QSM-00502	OCI error
QSM-00503	Out of memory
QSM-00504	Internal error
QSM-00505	Syntax error in <`parse_entity_name`> - <`error_description`>
QSM-00506	No fact-tables could be found
QSM-00507	No dimensions could be found
QSM-00508	Statistics missing on tables/columns
QSM-00509	Invalid parameter - <`parameter_name`>
QSM-00510	Statistics missing on summaries
QSM-00511	Invalid fact-tables specified in fact-filter
QSM-00512	Invalid summaries specified in the retention-list
QSM-00513	One or more of the workload tables is missing

26 DBMS_OLAP

Requirements

Error Messages

Table 26-1 DBMS_OLAP Error Messages

26
DBMS_OLAP