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: clear table fast ?

Re: clear table fast ?

From: Roger Wernersson <roger.wernersson_at_adra.se>
Date: 1997/01/14
Message-ID: <32DB4C69.3A50@adra.se>#1/1

axime wrote:
> I need to remove all (~100.000) rows from a (temporary) table.
> What is the fastest way to do this? Is it possible to do something like
> a 'modify to truncated' in Ingres, i.e. without logging the
> transactions?

Yes, you should do somethiog like this:

TRUNCATE TABLE my_table;

This removes all rows from the tale and you won't be able to roll back;

/Roger

-- 
Sport radio: people listening to people watching people having fun
Mailto:roger.wernersson_at_adra.se
BTW: All opinions are mine, all mine, and nobody's but mine.
Received on Tue Jan 14 1997 - 00:00:00 CST

Original text of this message

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