DBLINK 

VARCHAR2(128) 

NOT NULL 

Fully qualified pathname to the master database site for which you have scheduled periodic execution of deferred remote procedure calls. 

JOB 

NUMBER 

Number assigned to job when you created it by calling DBMS_DEFER_SYS.SCHEDULE_PUSH. Query the WHAT column of the USER_JOBS view to determine what is executed when the job is run. 

INTERVAL 

VARCHAR2(200) 

Function used to calculate the next time to push the deferred transaction queue to destination. 

NEXT_DATE 

DATE 

Next date that job is scheduled to be executed. 

LAST_DATE 

DATE 

Last time the queue was pushed (or attempted to push) remote procedure calls to this destination. 

DISABLED 

CHAR(1) 

If Y then propagation to destination is disabled.

If N then propagation to the destination is enabled. 

LAST_TXN_COUNT 

NUMBER 

Number of transactions pushed during last attempt. 

LAST_ERROR_NUMBER 

NUMBER 

Oracle error number from last push.  

LAST_ERROR_MESSAGE 

VARCHAR2(2000) 

Error message from last push.