[Home] [Help] [Dependency Information]
Object Name: | DEF$_ERROR |
---|---|
Object Type: | TABLE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
Information about all deferred transactions that caused an error
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
DEF$_ERROR_PRIMARY | NORMAL | UNIQUE | SYSTEM | ENQ_TID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ENQ_TID | VARCHAR2 | (22) | Yes | The ID of the transaction that created the error |
ORIGIN_TRAN_DB | VARCHAR2 | (128) | The database originating the deferred transaction | |
ORIGIN_ENQ_TID | VARCHAR2 | (22) | The original ID of the transaction | |
DESTINATION | VARCHAR2 | (128) | Database link used to address destination | |
STEP_NO | NUMBER | Unique ID of call that caused an error | ||
RECEIVER | NUMBER | User ID of the original receiver | ||
ENQ_TIME | DATE | Time original transaction enqueued | ||
ERROR_NUMBER | NUMBER | Oracle error number | ||
ERROR_MSG | VARCHAR2 | (2000) | Error message text |
Cut, paste (and edit) the following text to query this object:
SELECT ENQ_TID
, ORIGIN_TRAN_DB
, ORIGIN_ENQ_TID
, DESTINATION
, STEP_NO
, RECEIVER
, ENQ_TIME
, ERROR_NUMBER
, ERROR_MSG
FROM SYSTEM.DEF$_ERROR;
SYSTEM.DEF$_ERROR does not reference any database object
SYSTEM.DEF$_ERROR is referenced by following:
|
|
|