Re: clear table fast ?

From: Vijay Vardhineni <vardhineni_at_worldnet.att.net>
Date: 1997/01/14
Message-ID: <01bc023d$2a3f8dc0$9f6993cf@default>#1/1

you need to execute

TRUNCATE TABLE owner.table_name;

-- 
Vijaya Kumar Vardhineni
Certified Oracle DBA, EDS
Plano, TX

axime <axime_at_ipf.de> wrote in article <32D9F376.41C6_at_ipf.de>...


> 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 Tue Jan 14 1997 - 00:00:00 CST