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

TABLE: OLAPSYS.CWM$DOMAIN

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: CWM$DOMAIN_PK
  1. ColumnIRID
Unique Key: CWM$DOMAIN_UK
  1. ColumnNAME
  2. ColumnDEFINITIONMODEL_IRID
Indexes
Index Type Uniqueness Tablespace Column
CWM$DOMAIN_PK NORMAL UNIQUE TablespaceSYSAUX ColumnIRID
Foreign Keys
Table
Foreign Table Foreign Key Column
CWM$DOMAIN CWM$DOMAIN_FK TableCWM$MODEL CWM$DOMAIN DEFINITIONMODEL_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

TYPE_IRID NUMBER (38)
MAXIMUMPRECISION NUMBER

AVERAGEPRECISION NUMBER

SCALE NUMBER

AVERAGELENGTH NUMBER

MAXIMUMLENGTH NUMBER

DEFINITIONMODEL_IRID NUMBER (38) Yes
ITEM_IRID_1 NUMBER (38)
ITEM_IRID NUMBER (38) Yes
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
,      TYPE_IRID
,      MAXIMUMPRECISION
,      AVERAGEPRECISION
,      SCALE
,      AVERAGELENGTH
,      MAXIMUMLENGTH
,      DEFINITIONMODEL_IRID
,      ITEM_IRID_1
,      ITEM_IRID
,      DATE_CHANGED
,      DATE_CREATED
,      IVID
,      NOTM
,      TYPES
,      USER_CHANGED_BY
,      USER_CREATED_BY
FROM OLAPSYS.CWM$DOMAIN;

Dependencies

[top of page]

OLAPSYS.CWM$DOMAIN does not reference any database object

OLAPSYS.CWM$DOMAIN is referenced by following:

SchemaOLAPSYS
ViewALL$OLAP_FUNCTION_PARAMETERS
Package BodyCWM$UTIL - show dependent code
ViewDBA$OLAP_FUNCTION_PARAMETERS