Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Mass delete (about 100.000 records) ??

Mass delete (about 100.000 records) ??

From: Andreas Eggen <Andreas_Eggen_at_t-online.de>
Date: Fri, 4 Feb 2000 19:33:21 +0100
Message-ID: <87f65e$7p$1@news04.btx.dtag.de> 





Hi,



i have the question how to delete about 100.000 records in an oracle table.



we do this with an sql statement that select the records to delete and then
perform the action.



The Problem is, deleting of all records takes about 2 Hours ??



Anyone here in the group who has a solution for this problem ??



thanks in advance



Andi


Received on Fri Feb 04 2000 - 12:33:21 CST












Original text of this message













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