[Home] [Help]
[Dependency Information]
TABLE: SYS.DIMATTR$
Object Details
Object Name: | DIMATTR$ |
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSTEM |
PCT Free: | 10 |
PCT Used: | 40 |
Indexes
Index |
Type |
Uniqueness |
Tablespace |
Column |
I_DIMATTR$_1
|
NORMAL
|
NONUNIQUE
|
SYSTEM
|
DIMOBJ#
LEVELID#
|
I_DIMATTR$_2
|
NORMAL
|
NONUNIQUE
|
SYSTEM
|
DETAILOBJ#
COL#
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
DIMOBJ# |
NUMBER |
|
Yes |
|
LEVELID# |
NUMBER |
|
Yes |
|
DETAILOBJ# |
NUMBER |
|
Yes |
|
COL# |
NUMBER |
|
|
|
SPARE1 |
NUMBER |
|
|
|
SPARE2 |
NUMBER |
|
|
|
SPARE3 |
VARCHAR2 |
(1000) |
|
|
SPARE4 |
DATE |
|
|
|
ATTNAME |
VARCHAR2 |
(128) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT DIMOBJ#
, LEVELID#
, DETAILOBJ#
, COL#
, SPARE1
, SPARE2
, SPARE3
, SPARE4
, ATTNAME
FROM SYS.DIMATTR$;
Dependencies
[top of page]
SYS.DIMATTR$ does not reference any database object
SYS.DIMATTR$ is referenced by following:
-
OLAPSYS
-
ALL$OLAP2UDIM_LEVEL_ATTRIBUTES
-
ALL$OLAP2UDIM_LEVEL_ATTR_MAPS
-
ALL$OLAPMR_ATTRIBUTES
-
ALL$OLAP_DIM_ATTR_USES
-
ALL$OLAP_DIM_LEVEL_ATTRIBUTES
-
ALL$OLAP_DIM_LEVEL_ATTR_MAPS
-
CWM$EXPORT
- show dependent code
-
CWM$OLAP$DIM$ATTRIBUTE
- show dependent code
-
CWM$OLAP$LEVEL$ATTRIBUTE
- show dependent code
-
CWM$UTILITY
- show dependent code
-
CWM2_OLAP_METADATA_REFRESH
- show dependent code
-
DBA$OLAP2UDIM_LEVEL_ATTRIBUTES
-
DBA$OLAP2UDIM_LEVEL_ATTR_MAPS
-
DBA$OLAP_DIM_ATTR_USES
-
DBA$OLAP_DIM_LEVEL_ATTRIBUTES
-
DBA$OLAP_DIM_LEVEL_ATTR_MAPS
-
SYS
-
ALL_DIM_ATTRIBUTES
-
DBA_DIM_ATTRIBUTES
-
USER_DIM_ATTRIBUTES