Dear community,
Thanks for the help.
We have a transaction system and the project is to migrate the whole db to another data model in a new db
The middle tier java service stays the same.
Many of the migration code is slow due to the fact that we are doing a group by to de-dedup and clean out the data so it conforms the business logic of the new data model.
so we are not using append no logging during the load.
I wonder if we use dbms_errlog and dml log errors and just let the some of the data fails but take away the group by
Thanks for all the inputs!