DBA Data[Home] [Help]

VIEW: SYS._DBA_APPLY_ERROR_TXN

Source

View Text - Preformatted

select
  local_transaction_id, txn_message_number, msg_id, error_number,
  error_message, flags, spare1, spare2, spare3, spare4, spare5, spare6,
  message, source_object_owner, source_object_name, dest_object_owner,
  dest_object_name, primary_key, position, message_flags, operation,
  seq#, rba, index#
from sys.apply$_error_txn
View Text - HTML Formatted

SELECT LOCAL_TRANSACTION_ID
, TXN_MESSAGE_NUMBER
, MSG_ID
, ERROR_NUMBER
, ERROR_MESSAGE
, FLAGS
, SPARE1
, SPARE2
, SPARE3
, SPARE4
, SPARE5
, SPARE6
, MESSAGE
, SOURCE_OBJECT_OWNER
, SOURCE_OBJECT_NAME
, DEST_OBJECT_OWNER
, DEST_OBJECT_NAME
, PRIMARY_KEY
, POSITION
, MESSAGE_FLAGS
, OPERATION
, SEQ#
, RBA
, INDEX# FROM SYS.APPLY$_ERROR_TXN