Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
ALL_DIMENSIONS
describes the dimension objects accessible to the current user.
DBA_DIMENSIONS
describes all dimensions in the database.
USER_DIMENSIONS
describes the dimensions in the current user's schema.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the dimension |
DIMENSION_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the dimension |
INVALID |
VARCHAR2(1) |
Indicates whether the dimension is invalid (Y ) or valid (N ) |
|
COMPILE_STATE |
VARCHAR2(13) |
Compile status of the dimension:
|
|
REVISION |
NUMBER |
Dimension revision level |