ALL_AW_PS

ALL_AW_PS describes the pagespaces in the analytic workspaces accessible to the current user.

Related Views

  • DBA_AW_PS describes the pagespaces in all analytic workspaces in the database.

  • USER_AW_PS describes the pagespaces in 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 NOT NULL Number of the analytic workspace
AW_NAME VARCHAR2(30)   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

See Also: