DBA Data[Home] [Help]

VIEW: SYS.DBA_APPLY_ERROR_MESSAGES

Source

View Text - Preformatted

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
View Text - HTML Formatted

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