[Home] [Help] [Dependency Information]
Object Name: | ALL_DIMENSIONS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Description of the dimension objects accessible to the DBA
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Owner of the dimension |
DIMENSION_NAME | VARCHAR2 | (128) | Yes | Name of the dimension |
INVALID | VARCHAR2 | (1) | Invalidity of the dimension, Y = INVALID, N = VALID. The column is deprecated, please use COMPILE_STATE instead. | |
COMPILE_STATE | VARCHAR2 | (13) | Compile status of the dimension, VALID/NEEDS_COMPILE/ERROR | |
REVISION | NUMBER | Revision levle of the dimension |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, DIMENSION_NAME
, INVALID
, COMPILE_STATE
, REVISION
FROM SYS.ALL_DIMENSIONS;
|
|
|