Re: doing a transaction that is not logged

From: Peter van Rijn <p.vanrijnREMOVE_at_THISzhew.nl>
Date: Wed, 11 Dec 2002 12:52:20 +0100
Message-ID: <uve9nstbfj12c4@corp.supernews.com>

Francis,

If the number of records remaining after the delete is comparatively small you might consider creating a new table from the old one (CREATE TABLE AS SELECT), drop the old one and rename it. This might turn out a lot faster.

Peter

"Francis Drai" <francis.drai_at_sita.int> schreef in bericht news:3DF725DA.A9060E63_at_sita.int...
> Hello,
>
> AS I have to delete more than 100,000,000 records for a table I would
> like to be able to do this operation without journalization. So I will
> not have pb regarding temporary tablespace. Is it possible. I know that
> this is possible for some other databases.
>
> Thank you
Received on Wed Dec 11 2002 - 05:52:20 CST