Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: clear table fast ?
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 SmithReceived on Tue Jan 14 1997 - 00:00:00 CST