DBA Data[Home] [Help] [Dependency Information]

TABLE: OLAPSYS.CWM2$MRALL_FACTTBLKEYMAPS

Object Details
Object Name: CWM2$MRALL_FACTTBLKEYMAPS
Object Type: TABLE
Owner: OLAPSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30)
CUBE_NAME VARCHAR2 (30)
DIM_HIER_COMBO_ID NUMBER

DIMENSION_OWNER VARCHAR2 (30)
DIMENSION_NAME VARCHAR2 (30)
HIERARCHY_NAME VARCHAR2 (30)
LEVEL_NAME VARCHAR2 (30)
FACT_TABLE_OWNER VARCHAR2 (30)
FACT_TABLE_NAME VARCHAR2 (30)
COLUMN_NAME VARCHAR2 (30)
COLUMN_DATA_TYPE VARCHAR2 (106)
COLUMN_DATA_LENGTH NUMBER

COLUMN_DATA_PRECISION NUMBER

GID_COLUMN_NAME VARCHAR2 (30)
GID_COLUMN_DATA_TYPE VARCHAR2 (106)
GID_COLUMN_DATA_LENGTH NUMBER

GID_COLUMN_DATA_PRECISION NUMBER

DIMENSION_KEYMAP_TYPE NUMBER

MV_SUMMARYCODE VARCHAR2 (2)
COLUMN_POSITION NUMBER

VERSION_ID CHAR (4)
ID NUMBER

TABLE_ID NUMBER

COLUMN_ID NUMBER

GIDCOLUMN_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      CUBE_NAME
,      DIM_HIER_COMBO_ID
,      DIMENSION_OWNER
,      DIMENSION_NAME
,      HIERARCHY_NAME
,      LEVEL_NAME
,      FACT_TABLE_OWNER
,      FACT_TABLE_NAME
,      COLUMN_NAME
,      COLUMN_DATA_TYPE
,      COLUMN_DATA_LENGTH
,      COLUMN_DATA_PRECISION
,      GID_COLUMN_NAME
,      GID_COLUMN_DATA_TYPE
,      GID_COLUMN_DATA_LENGTH
,      GID_COLUMN_DATA_PRECISION
,      DIMENSION_KEYMAP_TYPE
,      MV_SUMMARYCODE
,      COLUMN_POSITION
,      VERSION_ID
,      ID
,      TABLE_ID
,      COLUMN_ID
,      GIDCOLUMN_ID
FROM OLAPSYS.CWM2$MRALL_FACTTBLKEYMAPS;

Dependencies

[top of page]

OLAPSYS.CWM2$MRALL_FACTTBLKEYMAPS does not reference any database object

OLAPSYS.CWM2$MRALL_FACTTBLKEYMAPS is referenced by following:

SchemaOLAPSYS
Package BodyCWM2_OLAP_METADATA_REFRESH - show dependent code
ViewMRV$OLAP2_FACTTBLKEYMAPS