How to fix apply errors?
I have a Streams setup (downstream, schema level) between two databases (v 10.2). Due to a tablespace gone full on target, I now have a situation with several thousend error LCR's caused by 'ORA-01403: no data found' errors, due to mismatch between 'old value' in source and 'current value' in target. This is too much to try to fix by modifying column values in target....
How to best resolve this issue? Do I have to reinstantiate the schemas in target database, or could I use the DBMS_APPLY_ADM.SET_UPDATE_CONFLICT_HANDLER package with method_name=OVERWRITE, and then retry the transactions? It's mostly the same two columns in the same table thar fails. I know the source tables are correct, and I'm happy with an 'forced' overwrite in the target.