[Home] [Help] [Dependency Information]

TABLE: OLAPSYS.CWM2$AWCUBELOAD

Object Details

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: CWM2$AWCUBELOAD_PK

1. IRID

Unique Key: CWM2$AWCUBELOAD_NAME

1. CUBE_IRID
2. VERSION_ID
3. NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
CWM2$AWCUBELOAD_NAME	NORMAL	UNIQUE	SYSAUX	CUBE_IRID VERSION_ID NAME
CWM2$AWCUBELOAD_PK	NORMAL	UNIQUE	SYSAUX	IRID

Foreign Keys

Table		Foreign Table	Foreign Key Column
CWM2$AWCUBECOMPPLAN		CWM2$AWCUBELOAD	CWM2$AWCUBECOMPPLAN CUBELOAD_IRID
CWM2$AWCUBELOADAGGPLAN		CWM2$AWCUBELOAD	CWM2$AWCUBELOADAGGPLAN CUBELOAD_IRID
CWM2$AWCUBELOADFILTER		CWM2$AWCUBELOAD	CWM2$AWCUBELOADFILTER CUBELOAD_IRID
CWM2$AWCUBELOADMEASURE		CWM2$AWCUBELOAD	CWM2$AWCUBELOADMEASURE CUBELOAD_IRID
CWM2$AWCUBELOADPARMVALUE		CWM2$AWCUBELOAD	CWM2$AWCUBELOADPARMVALUE CUBELOAD_IRID

Columns

Query Text

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

SELECT IRID
,      CUBE_IRID
,      VERSION_ID
,      NAME
,      LOADTYPE_IRID
,      CREATEDDATE
,      UPDATEDDATE
,      LASTCHANGEUSER
FROM OLAPSYS.CWM2$AWCUBELOAD;

Dependencies

[top of page]

OLAPSYS.CWM2$AWCUBELOAD does not reference any database object

OLAPSYS.CWM2$AWCUBELOAD is referenced by following:

OLAPSYS

ALL$AW_LOAD_CUBES

ALL$AW_LOAD_CUBE_AGG_LEVELS

ALL$AW_LOAD_CUBE_AGG_MEASURES

ALL$AW_LOAD_CUBE_DIMS

ALL$AW_LOAD_CUBE_MAP

ALL$AW_LOAD_CUBE_SEGWIDTH

CWM$CUBEDEL

CWM$MEASUREDEL

CWM2$AWCUBELOADUPD

CWM2$CUBEDEL

CWM2$MEASUREDEL

DBMS_AWM - show dependent code

DBMS_AWM_PRV - show dependent code

DBMS_AWM_PRV - show dependent code