Re: Database not returning from 'delete'!!

From: Shmooth <shmooth_at_yahoo.com>
Date: Mon, 04 Oct 1999 21:13:25 GMT
Message-ID: <37F91753.240C53AB@yahoo.com>

well, I'm returning now. I've increased (12x) the size of my rollback segments!

thanks.

Shmooth wrote:

> 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
> problems. I heard that I should make sure I have enough room in my
> rollback segments. I know what a rollback segment is, I just don't know
> how to look at, change the size of, whatever it!
>
> I can 'select count(*)' from this table, but that's it. I've also tried
> 'truncate', but it doesn't return either. What of the admin tools might
> be useful?
>
> thanks.
Received on Mon Oct 04 1999 - 16:13:25 CDT