ALL_DIMENSIONS
ALL_DIMENSIONS describes the dimension objects accessible to the current user.
Related Views
-
DBA_DIMENSIONSdescribes all dimensions in the database. -
USER_DIMENSIONSdescribes the dimensions in the current user’s schema.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the dimension |
DIMENSION_NAME |
VARCHAR2(128) |
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 |
See Also: