Re: Database not returning from 'delete'!!

From: TurkBear <johng_at_mm.com>
Date: Wed, 06 Oct 1999 13:55:16 GMT
Message-ID: <37fd5478.1242666@super.news-ituk.to>

If you want to keep the table structure, then use Truncate rather than drop...

like 'truncate table my_table'.

This is fast and non-recoverable...

"Thomas Frankewitsch" <franket_at_medsnt01.uni-muenster.de> wrote:

>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
>
>

-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---------- http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Wed Oct 06 1999 - 08:55:16 CDT