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

VIEW: SYS.DBA_AWS

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

Analytic Workspaces in the database

[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.DBA_AWS;

Dependencies

[top of page]

SYS.DBA_AWS references the following:

SchemaSYS
TableAW$
TablePS$
TableUSER$
SYS.DBA_AWS is referenced by following:

SchemaPUBLIC
SynonymDBA_AWS
SchemaSYS
ProcedureAW_REN_PROC - show dependent code
ProcedureAW_TRUNC_PROC - show dependent code
Package BodyDBMS_AW_EXP - show dependent code