ORA-30036: Unable to extend segment by 8192 in undo tablespace 'UNDOTBS'

Hi,

I'm running Oracle 9.2.0.1 on Solaris 8.

I wish to delete all rows from a table (there are 4716727 rows) and thus I have been using the following SQL command:

SQL>delete from reporter_status;

When I run the delete command I get the following error message after an approximate waiting time of 45 minutes;

ORA-30036: unable to extend segment by 8192 in undo tablespace 'UNDOTBS'

I then ran the following command to check if any rows had been deleted:

SQL>select count (*) from reporter_status;

The count returned 4716727 rows in the table. I then tried running the delete command again and got the same error message. Only this time the error message returned immediately.

How can I resolve this problem and ensure that all the rows in the table will be deleted?

Thanks,
Andy.