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: Database not returning from 'delete'!!

Re: Database not returning from 'delete'!!

From: Thomas Frankewitsch <franket_at_medsnt01.uni-muenster.de>
Date: Tue, 5 Oct 1999 22:11:49 +0200
Message-ID: <7tetuq$fv4$2@redenix.uni-muenster.de> 





faster: you want to delete all rows, I've found droppping a table is quite
faster than deleting all rows especially in the case of large counts!





Shmooth schrieb in Nachricht <37F8E2BD.A4F49D6F_at_yahoo.com>...


>I'm trying to delete all the rows from my table, 500,000 rows.  No


>matter the client (SQL*PLUS, various ODBC clients), the call never


>returns.  I'm not even sure where to begin to troubleshoot these





Received on Tue Oct 05 1999 - 15:11:49 CDT












Original text of this message













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