Re: delete data from table without rollback/logging?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 5 Oct 2001 05:00:57 +0200
Message-ID: <9pkpba$j6et6$1_at_ID-62141.news.dfncis.de>


"Steve Salvemini" <steve.salvemini_at_adelaide.edu.au> wrote in message news:3BBD190B.D3B36442_at_adelaide.edu.au...
> Hi group, I'm running a cut down script on a copy of a live database to
> remove some 90%
> of the data.
>
> Currently I use delete statements to remove the data from 100's of
> tables.
> Another method I can use is to copy out 10% into a temp table, truncate
> the original and
> then copy the 10% back in, reducing the hit on the rollback segments.
>
>
> Regardless of which option I take, is there a faster option to delete
> and insert data without filling up the rollback segments.
>
> I see 'alter table xxx nologging' doesn't seem to be affected by
> deletes.
>
> Ideally an 'alter session nologging' statement would be useful.
>
> Also, I would have dedicated use of this database, if that helps with
> any ideas.
>
>
> Cheers
>
> Steve

> Regardless of which option I take, is there a faster option to delete
> and insert data without filling up the rollback segments.
There is not.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Fri Oct 05 2001 - 05:00:57 CEST

Original text of this message