Re: Bypass logging mechanism

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 08 Feb 2000 18:06:01 +0800
Message-ID: <389FEA89.6CE6@yahoo.com>

rrenzo_at_my-deja.com wrote:
>
> In article <949663957.9037.0.pluto.d4ee154e_at_news.demon.nl>,
> "Sybrand Bakker" <postmaster_at_sybrandb.nospam.demon.nl> wrote:
> > read the manual and then use truncate table
>
> I was afraid of getting this answer.
> This will not help me out if only 90 percent of the table has to be
> truncated...
> Can you still help out?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

In this case, save the 10% somewhere else (create table as select ...) then truncate and re-insert.

Alternatively if this is a common occurrence then look at maybe using partioning and a rolling window mechanism

HTH
--

---

Connor McDonald
connor_mcdonald_at_yahoo.com

There are 3,434,679 oracle websites around the world. Now there is one more... http://www.oracledba.co.uk Received on Tue Feb 08 2000 - 04:06:01 CST