ALL_CUBE_VIEW_COLUMNS describes the columns of the relational views of the OLAP cubes accessible to the current user.
DBA_CUBE_VIEW_COLUMNS describes the columns of relational views of all OLAP cubes in the database.
USER_CUBE_VIEW_COLUMNS describes the columns of relational views of OLAP cubes owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
Owner of the cube | |
CUBE_NAME |
VARCHAR2(30) |
Name of a cube, such as UNITS_CUBE |
|
VIEW_NAME |
VARCHAR2(30) |
Name of a view of the cube, such as PRODUCT_VIEW |
|
COLUMN_NAME |
VARCHAR2(30) |
Name of a column in the view, such as DIM_KEY or LEVEL_NAME |
|
COLUMN_TYPE |
VARCHAR2(7) |
Type of the column:
|
|
OBJECT_NAME |
VARCHAR2(30) |
Name of the measure or dimension represented in the column |