Database Administration (MOSC)

MOSC Banner

Can redo logging for a single table be disabled?

edited Feb 12, 2009 4:00PM in Database Administration (MOSC) 1 commentAnswered
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. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center