This content has been marked as final. Show 4 replies
Try getting more information and post it
select MESSAGE_NUMBER, ERROR_NUMBER,ERROR_MESSAGE from dba_apply_error;
The errors that are reported in the table are the following:
These errors are repeated over and over again.
ORA-26787 The row with key... does not exist in the table <table_name> ORA-01403: no data found ORA-26786: A row with key... exits but has conflicting columns <column_list> in table <table_name> ORA-01403: no data found
I don't want to post the complete output because its about 80,000 rows.
As I mentioned, have created update conflict handlers for many of the tables and the errors were OVERIDDEN. But it seems like it is not working.
OK1 person found this helpful
Refer to this MOS note :
Master Note for Troubleshooting Streams Apply Errors ORA-1403, ORA-26787 or ORA-26786,Conflict Resolution [ID 265201.1]
Streams Recommended Patches [ID 437838.1]
Master Note for Streams Recommended Configuration [ID 418755.1]
Edited by: mseberg on Feb 14, 2013 11:42 AM
Thanks for your reply msberg.
I actually have seen those notes.
I was just wondering what could be causing those errors to keep on occuring non-stop even after I delete them. I understand that there are some conflicts occurring, but why does it keep on going? Strange.