Oracle 11gR2
OGG 11.1.1.1.5
I am getting the following error when updating a row that exists in both the target and source db:
OCI Error ORA-01403: no data found, SQL <UPDATE....
The following is in the discard file:
...
Record not found
Mapping problem with compressed key update record (target format)...
...
The row DOES exist in the target db for sure. But for some reason it thinks that it is not there...why?
Here are the exact steps I did:
1. Created a table in source
2. Create the same table in target (explicitly not through replication as we have an exclude filter on 'CREATE')
3. Inserted rows into source table (which were replicated to target table).
4. Delete a row in the source table (which were not applied to target as I am using the IGNOREDELETE parameter)
5. Update a row in the source table (this is where I got the above mentioned error 'ORA-1403' even though the row does exist.)