3.109 ALL_AWS

ALL_AWS describes the analytic workspaces accessible to the current user.

Related Views

• DBA_AWS describes all analytic workspaces in the database.

• USER_AWS describes the analytic workspaces owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(128)	NOT NULL	Owner of the analytic workspace
AW_NUMBER	NUMBER	NOT NULL	Number of the analytic workspace
AW_NAME	VARCHAR2(128)		Name of the analytic workspace
AW_VERSION	VARCHAR2(4)		Format version of the analytic workspace: 9.1 10.1 10.2 11.1
PAGESPACES	NUMBER		Number of pagespaces in the analytic workspace
GENERATIONS	NUMBER		Number of active generations in the analytic workspace
FROZEN	VARCHAR2(6)		Freeze state of the analytic workspace: Frozen NoThaw

See Also:

• "DBA_AWS"

• "USER_AWS"

• Oracle OLAP User’s Guide for more information about the OLAP option for Oracle Database