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

deleting large number of records from table...

From: bill <beers_at_mindspring.com>
Date: 1997/11/10
Message-ID: <647a9c$s51@camel12.mindspring.com>#1/1

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 Mon Nov 10 1997 - 00:00:00 CST

Original text of this message

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