Data Dictionary of Oracle 11g



Index | Home | Forums

Table Name Description
ALL_APPLY_ERROR Error transactions that were generated after dequeuing from the queue visible to the current user

Column ID Column name Data type Length Precision NULL Description
1APPLY_NAMEVARCHAR230(null)YName of the apply process at the local site which processed the transaction
2QUEUE_NAMEVARCHAR230(null)YName of the queue at the local site where the transaction came from
3QUEUE_OWNERVARCHAR230(null)YOwner of the queue at the local site where the transaction came from
4LOCAL_TRANSACTION_IDVARCHAR222(null)YLocal transaction ID for the error creation transaction
5SOURCE_DATABASEVARCHAR2128(null)YDatabase where the transaction originated
6SOURCE_TRANSACTION_IDVARCHAR222(null)YOriginal transaction ID at the source database
7SOURCE_COMMIT_SCNNUMBER22(null)YOriginal commit SCN for the transaction at the source database
8MESSAGE_NUMBERNUMBER22(null)YIdentifier for the message in the transaction that raised an error
9ERROR_NUMBERNUMBER22(null)YError number
10ERROR_MESSAGEVARCHAR24000(null)YError message
11RECIPIENT_IDNUMBER22(null)YUser ID of the original recipient
12RECIPIENT_NAMEVARCHAR230(null)YName of the original recipient
13MESSAGE_COUNTNUMBER22(null)YTotal number of messages inside the error transaction
14ERROR_CREATION_TIMEDATE7(null)YThe time that this error occurred

Index | Home | Forums

This page was created by oracleabc.com on Dec 31,2007 18:49:15
General comments and questions regarding this document should be sent by email to info@oracleabc.com or post your comments here