Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
|
|
View PDF |
ALL_AW_OBJ
lists the current objects in all analytic workspaces that are accessible to the user. The workspaces may have been created by DBMS_AWM
or by another tool, such as the OLAP Analytic Workspace API.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
User name of the analytic workspace owner |
AW_NUMBER |
NUMBER |
NOT NULL |
Unique identifier within the database for the analytic workspace |
AW_NAME |
VARCHAR2(30) |
Name of the analytic workspace | |
OBJ_ID |
NUMBER(20) |
Unique identifier for the object within the analytic workspace | |
OBJ_NAME |
VARCHAR2(256) |
Name of the object | |
OBJ_TYPE |
NUMBER(4) |
Data type of the object | |
PART_NAME |
VARCHAR2(256) |
Name of the partition for the object | |
FULL_PROPERTY_VALUE |