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


TABLE: OLAPSYS.CWM$PROJECT

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: CWM$PROJECT_PK
  1. ColumnIRID
Unique Key: CWM$PROJECT_UK
  1. ColumnNAME
Indexes
Index Type Uniqueness Tablespace Column
CWM$PROJECT_PK NORMAL UNIQUE TablespaceSYSAUX ColumnIRID
CWM$PROJECT_UK NORMAL UNIQUE TablespaceSYSAUX ColumnNAME
Foreign Keys
Table
Foreign Table Foreign Key Column
TableCWM$CLASSIFICATION CWM$CLASSIFICATION_FK CWM$PROJECT CWM$CLASSIFICATION PROJECT_IRID
TableCWM$CLASSIFICATIONTYPE CWM$CLASSIFICATIONTYPE_FK CWM$PROJECT CWM$CLASSIFICATIONTYPE PROJECT_IRID
TableCWM$MODEL CWM$MODEL_FK CWM$PROJECT CWM$MODEL PROJECT_IRID
TableCWM$OBJECTTYPE CWM$OBJECTTYPE_FK CWM$PROJECT CWM$OBJECTTYPE PROJECT_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

DATE_CHANGED DATE

DATE_CREATED DATE

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
,      DATE_CHANGED
,      DATE_CREATED
,      IVID
,      NOTM
,      TYPES
,      USER_CHANGED_BY
,      USER_CREATED_BY
FROM OLAPSYS.CWM$PROJECT;

Dependencies

[top of page]

OLAPSYS.CWM$PROJECT does not reference any database object

OLAPSYS.CWM$PROJECT is referenced by following:

SchemaOLAPSYS
Package BodyCWM$EXPORT - show dependent code
Package BodyCWM$UTIL - show dependent code
Package BodyCWM$UTILITY - show dependent code
Package BodyCWM2_OLAP_UTILITY - show dependent code