[Home] [Help] [Dependency Information]
Object Name: | PENDING_TRANS$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_PENDING_TRANS1 | NORMAL | UNIQUE | SYSTEM | LOCAL_TRAN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOCAL_TRAN_ID | VARCHAR2 | (22) | Yes | |
GLOBAL_TRAN_FMT | NUMBER | Yes | ||
GLOBAL_ORACLE_ID | VARCHAR2 | (64) | ||
GLOBAL_FOREIGN_ID | RAW | (64) | ||
TRAN_COMMENT | VARCHAR2 | (255) | ||
STATE | VARCHAR2 | (16) | Yes | |
STATUS | VARCHAR2 | (1) | Yes | |
HEURISTIC_DFLT | VARCHAR2 | (1) | ||
SESSION_VECTOR | RAW | (4) | Yes | |
RECO_VECTOR | RAW | (4) | Yes | |
TYPE# | NUMBER | |||
FAIL_TIME | DATE | Yes | ||
HEURISTIC_TIME | DATE | |||
RECO_TIME | DATE | Yes | ||
TOP_DB_USER | VARCHAR2 | (128) | ||
TOP_OS_USER | VARCHAR2 | (64) | ||
TOP_OS_HOST | VARCHAR2 | (128) | ||
TOP_OS_TERMINAL | VARCHAR2 | (255) | ||
GLOBAL_COMMIT# | VARCHAR2 | (16) | ||
SPARE1 | NUMBER | |||
SPARE2 | VARCHAR2 | (128) | ||
SPARE3 | NUMBER | |||
SPARE4 | VARCHAR2 | (128) |
Cut, paste (and edit) the following text to query this object:
SELECT LOCAL_TRAN_ID
, GLOBAL_TRAN_FMT
, GLOBAL_ORACLE_ID
, GLOBAL_FOREIGN_ID
, TRAN_COMMENT
, STATE
, STATUS
, HEURISTIC_DFLT
, SESSION_VECTOR
, RECO_VECTOR
, TYPE#
, FAIL_TIME
, HEURISTIC_TIME
, RECO_TIME
, TOP_DB_USER
, TOP_OS_USER
, TOP_OS_HOST
, TOP_OS_TERMINAL
, GLOBAL_COMMIT#
, SPARE1
, SPARE2
, SPARE3
, SPARE4
FROM SYS.PENDING_TRANS$;
SYS.PENDING_TRANS$ does not reference any database object
SYS.PENDING_TRANS$ is referenced by following:
|
|
|