| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
ALL_DIMENSIONS describes dimension objects accessible to the current user.
DBA_DIMENSIONS describes all dimensions in the database.
USER_DIMENSIONS describes 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 |
|
 Copyright © 2002, 2003, Oracle Corporation All Rights Reserved. |
|
