1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: ALL_ALL_TABLES to ALL_OUTLINES
  4. ALL_AWS

2.64 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: