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


TABLE: OLAPSYS.CWM2$AWCUBELOADMEASURE

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: CWM2$AWCUBELOADMEASURE_PK
  1. ColumnIRID
Unique Key: CWM2$AWCUBELOADMEASURE_NAME
  1. ColumnCUBELOAD_IRID
  2. ColumnNAME
Indexes
Index Type Uniqueness Tablespace Column
CWM2$AWCUBELOADMEASURE_NAME NORMAL UNIQUE TablespaceSYSAUX ColumnCUBELOAD_IRID
ColumnNAME
CWM2$AWCUBELOADMEASURE_PK NORMAL UNIQUE TablespaceSYSAUX ColumnIRID
Foreign Keys
Table
Foreign Table Foreign Key Column
CWM2$AWCUBELOADMEASURE CWM2$AWCUBELOADMEASURE_FK TableCWM2$AWCUBELOAD CWM2$AWCUBELOADMEASURE CUBELOAD_IRID
Columns
Name Datatype Length Mandatory Comments
IRID NUMBER
Yes
CUBELOAD_IRID NUMBER
Yes
MEASURE_IRID NUMBER
Yes
NAME VARCHAR2 (60)
DISPLAYNAME VARCHAR2 (60)
DESCRIPTION VARCHAR2 (4000)
CREATEDDATE DATE

UPDATEDDATE DATE

LASTCHANGEUSER VARCHAR2 (30)
Query Text

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


SELECT IRID
,      CUBELOAD_IRID
,      MEASURE_IRID
,      NAME
,      DISPLAYNAME
,      DESCRIPTION
,      CREATEDDATE
,      UPDATEDDATE
,      LASTCHANGEUSER
FROM OLAPSYS.CWM2$AWCUBELOADMEASURE;

Dependencies

[top of page]

OLAPSYS.CWM2$AWCUBELOADMEASURE does not reference any database object

OLAPSYS.CWM2$AWCUBELOADMEASURE is referenced by following:

SchemaOLAPSYS
ViewALL$AW_LOAD_CUBE_MEAS
TriggerCWM$MEASUREDEL
TriggerCWM2$AWCUBELOADMEASUREUPD
TriggerCWM2$MEASUREDEL
Package BodyDBMS_AWM - show dependent code
Package BodyDBMS_AWM_PRV - show dependent code
PL/SQL PackageDBMS_AWM_PRV - show dependent code