[Home] [Help] [Dependency Information]
Object Name: | SUMDEP$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_SUMDEP$_1 | NORMAL | NONUNIQUE | SYSTEM |
SUMOBJ#
ORDER# |
I_SUMDEP$_2 | NORMAL | NONUNIQUE | SYSTEM |
P_OBJ#
P_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUMOBJ# | NUMBER | Yes | ||
ORDER# | NUMBER | Yes | ||
P_OBJ# | NUMBER | Yes | ||
P_TYPE | NUMBER | Yes | ||
P_REF_TIME | DATE | |||
P_REF_SCN | NUMBER | |||
FLAGS | NUMBER | |||
INLINE# | NUMBER | |||
INSTANCE# | NUMBER | |||
QBCID | NUMBER | Yes | ||
SYN_OWN | VARCHAR2 | (128) | ||
SYN_NAME | VARCHAR2 | (128) | ||
SYN_MASTER | NUMBER | |||
VW_QUERY | LONG | (0) | ||
VW_QUERY_LEN | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SUMOBJ#
, ORDER#
, P_OBJ#
, P_TYPE
, P_REF_TIME
, P_REF_SCN
, FLAGS
, INLINE#
, INSTANCE#
, QBCID
, SYN_OWN
, SYN_NAME
, SYN_MASTER
, VW_QUERY
, VW_QUERY_LEN
FROM SYS.SUMDEP$;
SYS.SUMDEP$ does not reference any database object
SYS.SUMDEP$ is referenced by following:
|
|
|