Streams capture/apply fallen seriously behind
We have a real-time downstream environment in Oracle 10.2. A week ago, by mistake, a very long insert into a new table on source database was executed. This generated hundreds of archivelog were created in a couple of hours.. The table didn't even exist at the target database. Capture has fallen behind and is not able to read through the archived logs. This insert should never been executed, and the data is not needed/wanted at the target database. I have created the table in the target too, and made a negative rule on it, excluding it both from capture and