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


TABLE: OLAPSYS.CWM2$MRALL_FACTTBLFCTMAPS

Object Details
Object Name: CWM2$MRALL_FACTTBLFCTMAPS
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)
MEASURE_NAME VARCHAR2 (30)
DIM_HIER_COMBO_ID NUMBER

FACT_TABLE_OWNER VARCHAR2 (30)
FACT_TABLE_NAME VARCHAR2 (30)
COLUMN_NAME VARCHAR2 (30)
DATA_TYPE VARCHAR2 (106)
DATA_LENGTH NUMBER

DATA_PRECISION NUMBER

OLAP_API_DATA_TYPE NUMBER

VERSION_ID CHAR (4)
ID NUMBER

Query Text

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


SELECT OWNER
,      CUBE_NAME
,      MEASURE_NAME
,      DIM_HIER_COMBO_ID
,      FACT_TABLE_OWNER
,      FACT_TABLE_NAME
,      COLUMN_NAME
,      DATA_TYPE
,      DATA_LENGTH
,      DATA_PRECISION
,      OLAP_API_DATA_TYPE
,      VERSION_ID
,      ID
FROM OLAPSYS.CWM2$MRALL_FACTTBLFCTMAPS;

Dependencies

[top of page]

OLAPSYS.CWM2$MRALL_FACTTBLFCTMAPS does not reference any database object

OLAPSYS.CWM2$MRALL_FACTTBLFCTMAPS is referenced by following:

SchemaOLAPSYS
Package BodyCWM2_OLAP_METADATA_REFRESH - show dependent code
ViewMRV$OLAP2_FACTTBLFCTMAPS