3 DBMS_AW

The DBMS_AW package provides procedures and functions for interacting with analytic workspaces. With DBMS_AW, you can:

• Create, delete, copy, rename, and update analytic workspaces.

• Convert analytic workspaces from Oracle9i to Oracle 10g storage format.

• Attach analytic workspaces for processing within your session.

• Execute OLAP DML commands.

• Obtain information to help you manage sparsity and summary data within analytic workspaces.

This chapter includes the following topics:

• Managing Analytic Workspaces

• Embedding OLAP DML in SQL Statements

• Using the Sparsity Advisor

• Using the Aggregate Advisor

• Summary of DBMS_AW Subprograms