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: deleting large number of records from table...

Re: deleting large number of records from table...

From: Roy Klassen <rklassen_at_pei.sympatico.ca>
Date: 1997/11/11
Message-ID: <01bcee49$b3280920$051e22cf@fred.sympatico.ca>#1/1

Bill:

Why don't you use the truncate command? It will not use the rollback segments.

Roy Klassen rklassen_at_pei.sympatico.ca

bill <beers_at_mindspring.com> wrote in article <647a9c$s51_at_camel12.mindspring.com>...
> Could anyone give advice for deleting a large number of records from a
> table. I am trying to remove about 1,500,000 records and I am running
 out
> of rollback space. Would it be better to create a duplicate table
 structure
> and copy the few records to it, then drop the first table?
>
> Thanks in advance for any help.
> Bill
>
>
>
Received on Tue Nov 11 1997 - 00:00:00 CST

Original text of this message

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