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

VIEW: SYS.ALL_AW_PS

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

Pagespaces in 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
AW_NAME VARCHAR2 (128)
Name of the Analytic Workspace
PSNUMBER NUMBER (10)
Number of the pagespace
GENERATIONS NUMBER

Number of active generations in the pagespace
MAXPAGES NUMBER

Maximum pages allocated in the pagespace
Query Text

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


SELECT OWNER
,      AW_NUMBER
,      AW_NAME
,      PSNUMBER
,      GENERATIONS
,      MAXPAGES
FROM SYS.ALL_AW_PS;

Dependencies

[top of page]

SYS.ALL_AW_PS references the following:

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

SchemaPUBLIC
SynonymALL_AW_PS