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

VIEW: SYS.USER_AWS

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

Analytic Workspaces owned by the user

[View Source]

Columns
Name Datatype Length Mandatory Comments
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 AW_NUMBER
,      AW_NAME
,      AW_VERSION
,      PAGESPACES
,      GENERATIONS
,      FROZEN
FROM SYS.USER_AWS;

Dependencies

[top of page]

SYS.USER_AWS references the following:

SchemaSYS
TableAW$
TablePS$
SYS.USER_AWS is referenced by following:

SchemaPUBLIC
SynonymUSER_AWS