[Home] [Help] [Dependency Information]
Object Name: | DEF$_ORIGIN |
---|---|
Object Type: | TABLE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
Information about deferred transactions pushed to this site
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORIGIN_DB | VARCHAR2 | (128) | Originating database for the deferred transaction | |
ORIGIN_DBLINK | VARCHAR2 | (128) | Database link from deferred transaction origin to this site | |
INUSR | NUMBER | Connected user receiving the deferred transaction | ||
CSCN | NUMBER | Prepare SCN assigned at origin site | ||
ENQ_TID | VARCHAR2 | (22) | Transaction id assigned at origin site | |
RECO_SEQ_NO | NUMBER | Deferred transaction sequence number for recovery | ||
CATCHUP | RAW | (16) | Used to break transaction into pieces |
Cut, paste (and edit) the following text to query this object:
SELECT ORIGIN_DB
, ORIGIN_DBLINK
, INUSR
, CSCN
, ENQ_TID
, RECO_SEQ_NO
, CATCHUP
FROM SYSTEM.DEF$_ORIGIN;
SYSTEM.DEF$_ORIGIN does not reference any database object
SYSTEM.DEF$_ORIGIN is referenced by following:
|
|
|