[Home] [Help] [Dependency Information]
Object Name: | CDB_DIM_ATTRIBUTES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Representation of the relationship between a dimension level and
a functionally dependent column in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (30) | Yes | Owner of the dimentsion |
DIMENSION_NAME | VARCHAR2 | (30) | Yes | Name of the dimension |
ATTRIBUTE_NAME | VARCHAR2 | (128) | Name of the attribute | |
LEVEL_NAME | VARCHAR2 | (128) | Name of the hierarchy level | |
COLUMN_NAME | VARCHAR2 | (30) | Yes | Name of the dependent column |
INFERRED | CHAR | (1) | Whether this attribute is inferred from a JOIN KEY specification | |
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, DIMENSION_NAME
, ATTRIBUTE_NAME
, LEVEL_NAME
, COLUMN_NAME
, INFERRED
, CON_ID
FROM SYS.CDB_DIM_ATTRIBUTES;
SYS.CDB_DIM_ATTRIBUTES does not reference any database object
SYS.CDB_DIM_ATTRIBUTES is referenced by following:
|
|
|