[Home] [Help]
[Dependency Information]
TABLE: OLAPSYS.CWM2$DIMENSION
Object Details
Object Name: | CWM2$DIMENSION |
Object Type: | TABLE |
Owner: | OLAPSYS |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSAUX |
PCT Free: | 10 |
PCT Used: | |
Primary Key: CWM2$DIMENSION_PK
- IRID
Unique Key: CWM2$DIMENSION_NAME
- OWNER
- NAME
Indexes
Index |
Type |
Uniqueness |
Tablespace |
Column |
CWM2$DIMENSION_NAME
|
NORMAL
|
UNIQUE
|
SYSAUX
|
OWNER
NAME
|
CWM2$DIMENSION_PK
|
NORMAL
|
UNIQUE
|
SYSAUX
|
IRID
|
Foreign Keys
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
IRID |
NUMBER |
|
Yes |
|
OWNER |
VARCHAR2 |
(30) |
Yes |
|
NAME |
VARCHAR2 |
(30) |
Yes |
|
SHORTDESCRIPTION |
VARCHAR2 |
(240) |
|
|
DESCRIPTION |
VARCHAR2 |
(2000) |
|
|
DISPLAYNAME |
VARCHAR2 |
(90) |
|
|
PLURALNAME |
VARCHAR2 |
(90) |
|
|
DIMENSIONTYPE |
VARCHAR2 |
(10) |
|
|
INVALID |
VARCHAR2 |
(2) |
|
|
AW_DBOBJECTID |
NUMBER |
|
|
|
DEFAULTHIER_IRID |
NUMBER |
|
|
|
CREATEDDATE |
DATE |
|
|
|
UPDATEDDATE |
DATE |
|
|
|
LASTCHANGEUSER |
VARCHAR2 |
(30) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT IRID
, OWNER
, NAME
, SHORTDESCRIPTION
, DESCRIPTION
, DISPLAYNAME
, PLURALNAME
, DIMENSIONTYPE
, INVALID
, AW_DBOBJECTID
, DEFAULTHIER_IRID
, CREATEDDATE
, UPDATEDDATE
, LASTCHANGEUSER
FROM OLAPSYS.CWM2$DIMENSION;
Dependencies
[top of page]
OLAPSYS.CWM2$DIMENSION does not reference any database object
OLAPSYS.CWM2$DIMENSION is referenced by following:
-
OLAPSYS
-
ALL$AW_CUBE_AGG_LEVELS
-
ALL$AW_LOAD_CUBE_AGG_LEVELS
-
ALL$AW_LOAD_CUBE_DIMS
-
ALL$AW_LOAD_DIM_MAP
-
ALL$OLAP2UENTITY_EXT_PARMS
-
ALL$OLAP2UENTITY_PARAMETERS
-
ALL$OLAP2ULISTDIMS
-
ALL$OLAP2_AGG_OPERATOR_USES
-
ALL$OLAP2_AGG_WEIGHTBY_USES
-
ALL$OLAP2_CUBE_DIM_USES
-
ALL$OLAP2_CUBE_MEASURE_MAPS
-
ALL$OLAP2_CUBE_MEAS_DIM_USES
-
ALL$OLAP2_DIMENSIONS
-
ALL$OLAP2_DIM_ATTRIBUTES
-
ALL$OLAP2_DIM_ATTR_USES
-
ALL$OLAP2_DIM_HIERARCHIES
-
ALL$OLAP2_DIM_HIER_LEVEL_USES
-
ALL$OLAP2_DIM_LEVELS
-
ALL$OLAP2_DIM_LEVELS_KEYMAPS
-
ALL$OLAP2_DIM_LEVEL_ATTRIBUTES
-
ALL$OLAP2_DIM_LEVEL_ATTR_MAPS
-
ALL$OLAP2_ENTITY_DESC_USES
-
ALL$OLAP2_FACTTBLKEYMAPS
-
ALL$OLAP2_FACT_LEVEL_USES
-
ALL$OLAP2_FACT_TABLE_GID
-
ALL$OLAP2_HIER_CUSTOM_SORT
-
ALL$OLAP2_JOIN_KEY_COLUMN_USES
-
ALL$OLAP2_LEVEL_KEY_COL_USES
-
ALL$OLAP9I2_HIER_DIMENSIONS
-
CWM2$DIMENSIONDEL
-
CWM2$DIMENSIONUPD
-
CWM2_OLAP_CLASSIFY
- show dependent code
-
CWM2_OLAP_DIMENSION
- show dependent code
-
CWM2_OLAP_DIMENSION_ATTRIBUTE
- show dependent code
-
CWM2_OLAP_LEVEL_ATTRIBUTE
- show dependent code
-
CWM2_OLAP_METADATA_REFRESH
- show dependent code
-
CWM2_OLAP_MR_SESSION_POP
- show dependent code
-
CWM2_OLAP_UTILITY
- show dependent code
-
CWM2_OLAP_VALIDATE
- show dependent code
-
CWM2_OLAP_VALIDATE_METADATA
- show dependent code
-
DBA$OLAP2UENTITY_EXT_PARMS
-
DBA$OLAP2UENTITY_PARAMETERS
-
DBA$OLAP2ULISTDIMS
-
DBA$OLAP2_AGG_OPERATOR_USES
-
DBA$OLAP2_AGG_WEIGHTBY_USES
-
DBA$OLAP2_CUBE_DIM_USES
-
DBA$OLAP2_CUBE_MEASURE_MAPS
-
DBA$OLAP2_CUBE_MEAS_DIM_USES
-
DBA$OLAP2_DIMENSIONS
-
DBA$OLAP2_DIM_ATTRIBUTES
-
DBA$OLAP2_DIM_ATTR_USES
-
DBA$OLAP2_DIM_HIERARCHIES
-
DBA$OLAP2_DIM_HIER_LEVEL_USES
-
DBA$OLAP2_DIM_LEVELS
-
DBA$OLAP2_DIM_LEVELS_KEYMAPS
-
DBA$OLAP2_DIM_LEVEL_ATTRIBUTES
-
DBA$OLAP2_DIM_LEVEL_ATTR_MAPS
-
DBA$OLAP2_ENTITY_DESC_USES
-
DBA$OLAP2_FACTTBLKEYMAPS
-
DBA$OLAP2_FACT_LEVEL_USES
-
DBA$OLAP2_FACT_TABLE_GID
-
DBA$OLAP2_HIER_CUSTOM_SORT
-
DBA$OLAP2_JOIN_KEY_COLUMN_USES
-
DBA$OLAP2_LEVEL_KEY_COL_USES
-
DBA$OLAP9I2_HIER_DIMENSIONS
-
EXPORT2_DIM_HIER_LEVEL_USES
-
EXPORT2_ENTITY_DESC_USES
-
EXPORT2_JOIN_KEY_COLUMN_USES
-
EXPORTOLAP2_DIMENSIONS
-
MRV$OLAP2_POP_DIMENSIONS
-
ODM$OLAP2_DIM_HIER_LEVEL_USES
-
ODM$OLAP2_FACT_LEVEL_USES
-
ODM$OLAP2_JOIN_KEY_COLUMN_USES
-
ODM$OLAP2_LEVEL_KEY_COL_USES