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: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: 1997/01/14
Message-ID: <$uUrPJAVa42yEwF$@jimsmith.demon.co.uk>#1/1

In article <32D9F376.41C6_at_ipf.de>, axime <axime_at_ipf.de> writes
>Hi !
>
>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?
>
>
>TIA,
>Uwe

 Yes, There is a TRUNCATE TABLE command which does just what you want.

-- 
Jim Smith
Received on Tue Jan 14 1997 - 00:00:00 CST

Original text of this message

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