Skip Headers
Oracle® OLAP Reference
10g Release 2 (10.2)

Part Number B14350-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_OLAP2_AWS

ALL_OLAP2_AWS provides a list of all the analytic workspaces accessible to the current user. This includes both standard form and non-standard analytic workspaces.

Column Datatype NULL Description
OWNER VARCHAR2(30)
Owner of the analytic workspace.
AW VARCHAR2(30)
Name of the analytic workspace.
AW_NUMBER NUMBER
Unique identifier for the analytic workspace.
AW_VERSION VARCHAR2(4)
The version of the Database in which the analytic workspace was created. If the version is 10.1 or higher, the workspace is in 10g storage format. Earlier versions are in 9i format. To upgrade to 10g storage format, use the DBMS_AW.CONVERT procedure, as described in "Converting an Analytic Workspace to Oracle 10g Storage Format" .
SF_VERSION CHAR(8)
The version of the Database in which the standard form metadata was created. To upgrade to 10.1.0.3.1 standard form, use the DBMS_AWM.CREATE_DYNAMIC_AW_ACCESS procedure, as described in "CREATE_DYNAMIC_AW_ACCESS Procedure".