Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Too much redo! Help!

Re: Too much redo! Help!

From: Kenny Gump <kgump_at_mylanlabs.com>
Date: Thu, 7 Jan 1999 08:40:08 -0500
Message-ID: <3694b945.0@news.mountain.net>


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



Tabassam Kayani wrote in message <3693D0B8.15E36E5D_at_dial.pipex.com>...
>We have an overnight procedure which creates a large denormalised table
>by joining a number of existing tables. Unfortunately, more often than
>not, it fails to complete due to the large amount of redo generated
>(archived) and running out of disk space as a consequence.
>
>Bearing in mind that we are running under 7.1.6, can someone please
>suggest how we can keep the redo generated to an absolute minimum ?
>
>Thanks.
>
>
Received on Thu Jan 07 1999 - 07:40:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US