[Home] [Help] [Dependency Information]
Object Name: | WRI$_SEGADV_OBJLIST |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WRI$_SEGADV_OBJLIST_IDX_AID | NORMAL | NONUNIQUE | SYSTEM | AUTO_TASKID |
WRI$_SEGADV_OBJLIST_IDX_OBJ | NORMAL | NONUNIQUE | SYSTEM |
TS_ID
OBJN OBJD |
WRI$_SEGADV_OBJLIST_IDX_OBJD | NORMAL | NONUNIQUE | SYSTEM | OBJD |
WRI$_SEGADV_OBJLIST_IDX_TS | NORMAL | NONUNIQUE | SYSTEM | TS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUTO_TASKID | NUMBER | |||
TS_ID | NUMBER | |||
OBJN | NUMBER | |||
OBJD | NUMBER | |||
STATUS | VARCHAR2 | (40) | ||
TASK_ID | NUMBER | |||
REASON | VARCHAR2 | (40) | ||
REASON_VALUE | NUMBER | |||
CREATION_TIME | TIMESTAMP(6) | (11) | ||
PROC_TASKID | NUMBER | |||
END_TIME | TIMESTAMP(6) | (11) | ||
SEGMENT_OWNER | VARCHAR2 | (128) | ||
SEGMENT_NAME | VARCHAR2 | (128) | ||
PARTITION_NAME | VARCHAR2 | (128) | ||
SEGMENT_TYPE | VARCHAR2 | (18) | ||
TABLESPACE_NAME | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT AUTO_TASKID
, TS_ID
, OBJN
, OBJD
, STATUS
, TASK_ID
, REASON
, REASON_VALUE
, CREATION_TIME
, PROC_TASKID
, END_TIME
, SEGMENT_OWNER
, SEGMENT_NAME
, PARTITION_NAME
, SEGMENT_TYPE
, TABLESPACE_NAME
FROM SYS.WRI$_SEGADV_OBJLIST;
SYS.WRI$_SEGADV_OBJLIST does not reference any database object
SYS.WRI$_SEGADV_OBJLIST is referenced by following:
|
|
|