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: Bypass logging mechanism

Re: Bypass logging mechanism

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 8 Feb 2000 19:02:54 +0100
Message-ID: <950033111.1424.0.pluto.d4ee154e@news.demon.nl>


Try this one:

create table blabla_temp as
select *
from <table_to_be_truncated>
where <any clauses necessary to select the 10 percent>; commit; -- truncate will also commit, but now just for security.

truncate table <table_to_be_truncated>;

insert into <table_to_be_truncated>
select * from blabla_temp;

commit;

<rrenzo_at_my-deja.com> wrote in message news:87pgjs$o2r$1_at_nnrp1.deja.com...
> 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.
Received on Tue Feb 08 2000 - 12:02:54 CST

Original text of this message

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