| Table Name | Description |
| ALL_DIMENSIONS | Description of the dimension objects accessible to the DBA |
| Column ID | Column name | Data type | Length | Precision | NULL | Description |
| 1 | OWNER | VARCHAR2 | 30 | (null) | N | Owner of the dimension |
| 2 | DIMENSION_NAME | VARCHAR2 | 30 | (null) | N | Name of the dimension |
| 3 | INVALID | VARCHAR2 | 1 | (null) | Y | Invalidity of the dimension, Y = INVALID, N = VALID. The column is deprecated, please use COMPILE_STATE instead. |
| 4 | COMPILE_STATE | VARCHAR2 | 13 | (null) | Y | Compile status of the dimension, VALID/NEEDS_COMPILE/ERROR |
| 5 | REVISION | NUMBER | 22 | (null) | Y | Revision levle of the dimension |