[Home] [Help] [Dependency Information]
Object Name: | DBA$OLAPMR_FACTTBLKEYMAPS |
---|---|
Object Type: | VIEW |
Owner: | OLAPSYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (240) | ||
CUBE_NAME | VARCHAR2 | (240) | ||
DIMENSION_OWNER | VARCHAR2 | (30) | Yes | |
DIMENSION_NAME | VARCHAR2 | (30) | Yes | |
LEVEL_NAME | VARCHAR2 | (30) | Yes | |
FACT_TABLE_OWNER | VARCHAR2 | (30) | ||
FACT_TABLE_NAME | VARCHAR2 | (30) | ||
COLUMN_NAME | VARCHAR2 | (128) | Yes | |
COLUMN_POSITION | NUMBER | |||
MV_SUMMARY_CODE | VARCHAR2 | (2) |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, CUBE_NAME
, DIMENSION_OWNER
, DIMENSION_NAME
, LEVEL_NAME
, FACT_TABLE_OWNER
, FACT_TABLE_NAME
, COLUMN_NAME
, COLUMN_POSITION
, MV_SUMMARY_CODE
FROM OLAPSYS.DBA$OLAPMR_FACTTBLKEYMAPS;
|
|
|