DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.ALL_AWS

Object Details
Object Name: ALL_AWS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Analytic Workspaces accessible to the user

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the Analytic Workspace
AW_NUMBER NUMBER
Yes Number of the Analytic Workspace
AW_NAME VARCHAR2 (128)
Name of the Analytic Workspace
AW_VERSION VARCHAR2 (4)
Format version of the Analytic Workspace
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      AW_NUMBER
,      AW_NAME
,      AW_VERSION
,      PAGESPACES
,      GENERATIONS
,      FROZEN
FROM SYS.ALL_AWS;

Dependencies

[top of page]

SYS.ALL_AWS references the following:

SchemaSYS
TableAW$
TableOBJ$
TableOBJAUTH$
TablePS$
TableUSER$
SYS.ALL_AWS is referenced by following:

SchemaPUBLIC
SynonymALL_AWS
SchemaSYS
ViewALL$OLAP2_AWS
Package BodyDBMS_AW - show dependent code
Package BodyDBMS_AW_EXP - show dependent code
Package BodyDBMS_CUBE - show dependent code
Package BodyDBMS_CUBE_EXP - show dependent code