select msg_id, local_transaction_id, txn_message_number+1,
error_number, error_message, nvl(source_object_owner,dest_object_owner),
nvl(source_object_name, dest_object_name),
dest_object_owner, dest_object_name, primary_key, position, operation,
dbms_streams_lcr_int.get_lcr_content(
dbms_apply_adm.get_error_message(txn_message_number+1,
local_transaction_id), '*')
from sys.apply$_error_txn
SELECT MSG_ID
, LOCAL_TRANSACTION_ID
, TXN_MESSAGE_NUMBER+1
,
ERROR_NUMBER
, ERROR_MESSAGE
, NVL(SOURCE_OBJECT_OWNER
, DEST_OBJECT_OWNER)
,
NVL(SOURCE_OBJECT_NAME
, DEST_OBJECT_NAME)
,
DEST_OBJECT_OWNER
, DEST_OBJECT_NAME
, PRIMARY_KEY
, POSITION
, OPERATION
,
DBMS_STREAMS_LCR_INT.GET_LCR_CONTENT(
DBMS_APPLY_ADM.GET_ERROR_MESSAGE(TXN_MESSAGE_NUMBER+1
,
LOCAL_TRANSACTION_ID)
, '*')
FROM SYS.APPLY$_ERROR_TXN
|
|
|