Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: clear table fast ?
From my exprience, truncate tables in oracle checks R.I., an even faster way to do it is to disable the R.I. first then truncate table.
-- Minh Giang mpg_at_fast.net Vijay Vardhineni <vardhineni_at_worldnet.att.net> wrote in article <01bc023d$2a3f8dc0$9f6993cf_at_default>...Received on Sun Jan 19 1997 - 00:00:00 CST
> 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
> >
>