Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Too much redo! Help!
If you are recreating the table each time then in your create table
statement use the unrecoverable keyword option. This will cause only a
minimal amount of redo to be generated. Only segment growth, etc.
create table my_table
unrecoverable as
select .....
from....
Kenny Gump
OCP 7.3 DBA