Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Bypass logging mechanism
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