Can redo logging for a single table be disabled?
There is a table that is being truncated and then being inserted and updated to every 5 minutes by a scheduled job. Because of the frequency of the job, the amount of redo being generated is causing our DataGuard configuration to SLOW down considerably.
Is there a way to disable redo logging on the update portion of this table only?
Our database runs in archivelog mode and we want to maintain that
but this table we don't want redo generated.
We don't care about recovery of the table because it is being populated every 5 minutes with new data. We only care about the current data in the table.
0