Diasable redo log for the table
Posted on 2006-03-20
I have a table which is heavily inserted with data periodically and goes to the order of 5G over the period of 20days and then it is cleaned by trigger. So given point of time it holds only last 20days worth of data.
Question is I want to disable the redo log for this table so that when I recover the database I can skip this table as the data is not critical to recover and we can improve the recovery time by skipping it.
What is the best way to do it, I know there is NOARCHIVELOG option I can set, but according to ORacle documentation that one still generates logs and not reliable.