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


TABLE: OLAPSYS.CWM2$AWDIMLOADFILTER

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: CWM2$AWDIMLOADFILTER_PK
  1. ColumnIRID
Unique Key: CWM2$AWDIMLOADFILTER_ID
  1. ColumnDIMLOAD_IRID
  2. ColumnLOOKUP_TABLE_OWNER
  3. ColumnLOOKUP_TABLE_NAME
Indexes
Index Type Uniqueness Tablespace Column
CWM2$AWDIMLOADFILTER_ID NORMAL UNIQUE TablespaceSYSAUX ColumnDIMLOAD_IRID
ColumnLOOKUP_TABLE_OWNER
ColumnLOOKUP_TABLE_NAME
CWM2$AWDIMLOADFILTER_PK NORMAL UNIQUE TablespaceSYSAUX ColumnIRID
Foreign Keys
Table
Foreign Table Foreign Key Column
CWM2$AWDIMLOADFILTER CWM2$AWDIMLOADFILTER_FK1 TableCWM2$AWDIMLOAD CWM2$AWDIMLOADFILTER DIMLOAD_IRID
Columns
Name Datatype Length Mandatory Comments
IRID NUMBER
Yes
DIMLOAD_IRID NUMBER
Yes
LOOKUP_TABLE_OWNER VARCHAR2 (30)
LOOKUP_TABLE_NAME VARCHAR2 (30)
FILTERCONDITION VARCHAR2 (4000)
CREATEDDATE DATE

UPDATEDDATE DATE

LASTCHANGEUSER VARCHAR2 (30)
Query Text

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


SELECT IRID
,      DIMLOAD_IRID
,      LOOKUP_TABLE_OWNER
,      LOOKUP_TABLE_NAME
,      FILTERCONDITION
,      CREATEDDATE
,      UPDATEDDATE
,      LASTCHANGEUSER
FROM OLAPSYS.CWM2$AWDIMLOADFILTER;

Dependencies

[top of page]

OLAPSYS.CWM2$AWDIMLOADFILTER does not reference any database object

OLAPSYS.CWM2$AWDIMLOADFILTER is referenced by following:

SchemaOLAPSYS
ViewALL$AW_LOAD_DIM_FILT
TriggerCWM2$AWDIMLOADFILTERUPD
Package BodyDBMS_AWM - show dependent code
PL/SQL PackageDBMS_AWM_PRV - show dependent code
Package BodyDBMS_AWM_PRV - show dependent code