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


TABLE: OLAPSYS.CWM$ITEMMAP

Object Details
Object Name: CWM$ITEMMAP
Object Type: TABLE
Owner: OLAPSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: CWM$ITEMMAP_PK
  1. ColumnIRID
Indexes
Index Type Uniqueness Tablespace Column
CWM$ITEMMAP_PK NORMAL UNIQUE TablespaceSYSAUX ColumnIRID
Foreign Keys
Table
Foreign Table Foreign Key Column
TableCWM$ITEMUSE CWM$ITEMUSE_FK_1 CWM$ITEMMAP CWM$ITEMUSE OPERATION_IRID_1
TableCWM$ITEMUSE CWM$ITEMUSE_FK CWM$ITEMMAP CWM$ITEMUSE OPERATION_IRID
Columns
Name Datatype Length Mandatory Comments
IRID NUMBER (38) Yes
NAME VARCHAR2 (240)
SHORTDESCRIPTION VARCHAR2 (240)
DESCRIPTION VARCHAR2 (4000)
CREATEDBY VARCHAR2 (240)
CREATEDON DATE

LASTMODIFIEDBY VARCHAR2 (240)
LASTMODIFIEDON DATE

ENTITYMAP_IRID NUMBER (38) Yes
DATE_CHANGED DATE

DATE_CREATED DATE

ENTITYMAP_FK_SEQ NUMBER (28)
IVID NUMBER (38)
NOTM NUMBER (38)
TYPES NUMBER (38)
USER_CHANGED_BY VARCHAR2 (30)
USER_CREATED_BY VARCHAR2 (30)
Query Text

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


SELECT IRID
,      NAME
,      SHORTDESCRIPTION
,      DESCRIPTION
,      CREATEDBY
,      CREATEDON
,      LASTMODIFIEDBY
,      LASTMODIFIEDON
,      ENTITYMAP_IRID
,      DATE_CHANGED
,      DATE_CREATED
,      ENTITYMAP_FK_SEQ
,      IVID
,      NOTM
,      TYPES
,      USER_CHANGED_BY
,      USER_CREATED_BY
FROM OLAPSYS.CWM$ITEMMAP;

Dependencies

[top of page]

OLAPSYS.CWM$ITEMMAP does not reference any database object

OLAPSYS.CWM$ITEMMAP is referenced by following:

SchemaOLAPSYS
Package BodyCWM$OLAP$CUBE - show dependent code
Package BodyCWM$OLAP$DIM$ATTRIBUTE - show dependent code
Package BodyCWM$OLAP$MEASURE - show dependent code
Package BodyCWM$UTIL - show dependent code
Package BodyCWM$UTILITY - show dependent code