[Home] [Help] [Dependency Information]
Object Name: | SUM$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_SUM$_1 | NORMAL | UNIQUE | SYSTEM | OBJ# |
SYS_IL0000000318C00034$$ | LOB | UNIQUE | SYSTEM | |
SYS_IL0000000318C00035$$ | LOB | UNIQUE | SYSTEM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJ# | NUMBER | Yes | ||
CONTAINEROBJ# | NUMBER | Yes | ||
CONTAINERTYPE | NUMBER | Yes | ||
CONTAINERNAM | VARCHAR2 | (128) | ||
FULLREFRESHTIM | NUMBER | |||
INCREFRESHTIM | NUMBER | |||
LASTREFRESHSCN | NUMBER | |||
LASTREFRESHDATE | DATE | |||
REFRESHMODE | NUMBER | |||
PFLAGS | NUMBER | |||
MFLAGS | NUMBER | |||
NUMDETAILTAB | NUMBER | |||
NUMAGGREGATES | NUMBER | |||
NUMKEYCOLUMNS | NUMBER | |||
NUMJOINS | NUMBER | |||
SUMTEXTLEN | NUMBER | |||
SUMTEXT | LONG | (0) | ||
FROMOFFSET | NUMBER | Yes | ||
FROMLEN | NUMBER | Yes | ||
METAVERSION | NUMBER | Yes | ||
OBJCOUNT | NUMBER | Yes | ||
SPARE1 | NUMBER | |||
SPARE2 | NUMBER | |||
SPARE3 | VARCHAR2 | (1000) | ||
SPARE4 | DATE | |||
XPFLAGS | NUMBER | |||
NUMINLINES | NUMBER | |||
NUMWHRNODES | NUMBER | |||
NUMHAVNODES | NUMBER | |||
NUMQBNODES | NUMBER | |||
QBCMARKER | NUMBER | |||
MARKERDTY | NUMBER | |||
RW_NAME | VARCHAR2 | (128) | ||
SRC_STMT | CLOB | (4000) | ||
DEST_STMT | CLOB | (4000) | ||
RW_MODE | NUMBER | |||
ZMAPSCALE | NUMBER | |||
EVALEDITION# | NUMBER | |||
UNUSABLEBEFORE# | NUMBER | |||
UNUSABLEBEGINNING# | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT OBJ#
, CONTAINEROBJ#
, CONTAINERTYPE
, CONTAINERNAM
, FULLREFRESHTIM
, INCREFRESHTIM
, LASTREFRESHSCN
, LASTREFRESHDATE
, REFRESHMODE
, PFLAGS
, MFLAGS
, NUMDETAILTAB
, NUMAGGREGATES
, NUMKEYCOLUMNS
, NUMJOINS
, SUMTEXTLEN
, SUMTEXT
, FROMOFFSET
, FROMLEN
, METAVERSION
, OBJCOUNT
, SPARE1
, SPARE2
, SPARE3
, SPARE4
, XPFLAGS
, NUMINLINES
, NUMWHRNODES
, NUMHAVNODES
, NUMQBNODES
, QBCMARKER
, MARKERDTY
, RW_NAME
, SRC_STMT
, DEST_STMT
, RW_MODE
, ZMAPSCALE
, EVALEDITION#
, UNUSABLEBEFORE#
, UNUSABLEBEGINNING#
FROM SYS.SUM$;
SYS.SUM$ does not reference any database object
SYS.SUM$ is referenced by following:
|
|
|