Table: USER_DIMENSIONS
Description of the dimension objects accessible to the DBA
| Column Name | Description |
|---|---|
| COMPILE_STATE | Compile status of the dimension, VALID/NEEDS_COMPILE/ERROR |
| DIMENSION_NAME | Name of the dimension |
| INVALID | Invalidity of the dimension, Y = INVALID, N = VALID. The column is deprecated, please use COMPILE_STATE instead. |
| OWNER | Owner of the dimension |
| REVISION | Revision levle of the dimension |