Database not returning from 'delete'!!

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 - 12:29:03 CDT