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