Oracle9i Replication Management API Reference
Release 1 (9.0.1)

Part Number A87502-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Deferred Transaction Views, 6 of 11


DEFERROR

Contains the ID of each transaction that could not be applied. You can use this ID to locate the queued calls associated with this transaction. These calls are stored in the DEFCALL view. You can use the procedures in the DBMS_DEFER_QUERY package to determine the arguments to the procedures listed in the DEFCALL view.

Column  Datatype  NULL  Description 

DEFERRED_TRAN_ID 

VARCHAR2(22) 

NOT NULL 

The ID of the transaction causing the error. 

ORIGIN_TRAN_DB 

VARCHAR2(128) 

 

The database originating the deferred transaction. 

ORIGIN_TRAN_ID  

VARCHAR2(22) 

 

The original ID of the transaction. 

CALLNO 

NUMBER 

 

Unique ID of the call at DEFERRED_TRAN_ID

DESTINATION 

VARCHAR2(128) 

 

Database link used to address destination. 

START_TIME 

DATE 

 

Time when the original transaction was enqueued. 

ERROR_NUMBER 

NUMBER 

 

Oracle error number. 

ERROR_MSG 

VARCHAR2(2000) 

 

Error message text. 

RECEIVER 

VARCHAR2(30) 

 

Original receiver of the deferred transaction. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback