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

clear table fast ?

From: axime <axime_at_ipf.de>
Date: 1997/01/13
Message-ID: <32D9F376.41C6@ipf.de>#1/1

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 Received on Mon Jan 13 1997 - 00:00:00 CST

Original text of this message

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