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(30) NOT NULL Owner of the analytic workspace
AW_NUMBER NUMBER   Number of the analytic workspace
AW_NAME VARCHAR2(30)   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: