Static Data Dictionary Views, 23 of 452

ALL_DIM_JOIN_KEY

ALL_DIM_JOIN_KEY describes the joins between two dimension tables that are accessible to the current user. The join is always specified between a parent dimension level column and a child column.

Related views:

DBA_DIM_JOIN_KEY describes all such joins in the database.

USER_DIM_JOIN_KEY describes all such joins owned by the current user.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension

DIM_KEY_ID

NUMBER

NOT NULL

Unique within a dimension

LEVEL_NAME

VARCHAR2(30)

Name of the hierarchy level

KEY_POSITION

NUMBER

NOT NULL

Ordinal position of the key column within the level

HIERARCHY_NAME

VARCHAR2(30)

Name of the key column

CHILD_JOIN_COLUMN

VARCHAR2(30)

NOT NULL

Name of the join column

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the dimension
`DIMENSION_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the dimension
`DIM_KEY_ID`	`NUMBER`	`NOT NULL`	Unique within a dimension
`LEVEL_NAME`	`VARCHAR2(30)`		Name of the hierarchy level
`KEY_POSITION`	`NUMBER`	`NOT NULL`	Ordinal position of the key column within the level
`HIERARCHY_NAME`	`VARCHAR2(30)`		Name of the key column
`CHILD_JOIN_COLUMN`	`VARCHAR2(30)`	`NOT NULL`	Name of the join column