| 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 |