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


TABLE: OLAPSYS.CWM2$AWCUBELOADPARMVALUE

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: CWM2$AWCUBELOADPARMVALUE_PK
  1. ColumnIRID
Unique Key: CWM2$AWCUBELOADPARMVALUE_ID
  1. ColumnCUBELOAD_IRID
  2. ColumnPARMNAME_IRID
Indexes
Index Type Uniqueness Tablespace Column
CWM2$AWCUBELOADPARMVALUE_ID NORMAL UNIQUE TablespaceSYSAUX ColumnCUBELOAD_IRID
ColumnPARMNAME_IRID
CWM2$AWCUBELOADPARMVALUE_PK NORMAL UNIQUE TablespaceSYSAUX ColumnIRID
Foreign Keys
Table
Foreign Table Foreign Key Column
CWM2$AWCUBELOADPARMVALUE CWM2$AWCUBELOADPARMVALUE_FK1 TableCWM2$AWCUBELOAD CWM2$AWCUBELOADPARMVALUE CUBELOAD_IRID
Columns
Name Datatype Length Mandatory Comments
IRID NUMBER
Yes
CUBELOAD_IRID NUMBER
Yes
PARMNAME_IRID NUMBER
Yes
VALUE 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
,      PARMNAME_IRID
,      VALUE
,      CREATEDDATE
,      UPDATEDDATE
,      LASTCHANGEUSER
FROM OLAPSYS.CWM2$AWCUBELOADPARMVALUE;

Dependencies

[top of page]

OLAPSYS.CWM2$AWCUBELOADPARMVALUE does not reference any database object

OLAPSYS.CWM2$AWCUBELOADPARMVALUE is referenced by following:

SchemaOLAPSYS
ViewALL$AW_LOAD_CUBE_PARM
TriggerCWM2$AWCUBELOADPARMVALUEUPD
Package BodyDBMS_AWM - show dependent code
PL/SQL PackageDBMS_AWM_PRV - show dependent code
Package BodyDBMS_AWM_PRV - show dependent code