| Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
|
|
View PDF |
| Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
|
|
View PDF |
ALL_AW_PROP lists the current OLAP DML properties and their values 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 | |
PROPERTY_NAME |
VARCHAR2(256) |
Name of the property | |
PROPERTY_TYPE |
VARCHAR2(4000) |
Data type of the property value | |
PROPERTY_VALUE |
VARCHAR2(4000) |
Value of the property | |
FULL_PROPERTY_VALUE |
CLOB |
Full value of the property | |
PROPERTY_VALUE_LENGTH |
NUMBER |
Length of the property value |
