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. |