Skip to content

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

TABLE: OLAPSYS.CWM$OBJECTTYPE

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: CWM$OBJECTTYPE_PK
  1. ColumnIRID
Indexes
Index Type Uniqueness Tablespace Column
CWM$OBJECTTYPE_PK NORMAL UNIQUE TablespaceSYSAUX ColumnIRID
CWM$OBJECTTYPE_IDX NORMAL NONUNIQUE TablespaceSYSAUX ColumnNAME
ColumnCLASSIFICATIONTYPE_IRID
Foreign Keys
Table
Foreign Table Foreign Key Column
CWM$OBJECTTYPE CWM$OBJECTTYPE_FK_1 TableCWM$CLASSIFICATIONTYPE CWM$OBJECTTYPE CLASSIFICATIONTYPE_IRID
CWM$OBJECTTYPE CWM$OBJECTTYPE_FK TableCWM$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

PROJECT_IRID NUMBER (38) Yes
CONFIGURATIONTEMPLATESET_IRID NUMBER (38)
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)
CLASSIFICATIONTYPE_IRID NUMBER (38)
Query Text

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


SELECT IRID
,      NAME
,      SHORTDESCRIPTION
,      DESCRIPTION
,      CREATEDBY
,      CREATEDON
,      LASTMODIFIEDBY
,      LASTMODIFIEDON
,      PROJECT_IRID
,      CONFIGURATIONTEMPLATESET_IRID
,      DATE_CHANGED
,      DATE_CREATED
,      IVID
,      NOTM
,      TYPES
,      USER_CHANGED_BY
,      USER_CREATED_BY
,      CLASSIFICATIONTYPE_IRID
FROM OLAPSYS.CWM$OBJECTTYPE;

Dependencies

[top of page]

OLAPSYS.CWM$OBJECTTYPE does not reference any database object

OLAPSYS.CWM$OBJECTTYPE is referenced by following:

SchemaOLAPSYS
ViewALL$OLAP_DESCRIPTOR_TYPES
Package BodyCWM$CLASSIFY - show dependent code
ViewDBA$OLAP_DESCRIPTOR_TYPES