housekeeping database

I am trying to a Oracle sql script to do some housekeeping but I am not very familiar with PL/SQL.

What I want to achieve is something like this :

        delete from TABLE_A where processed_i = 1

However, I keep getting "rollback segment too small" problem as the table is quite huge.

So I am thinking of doing something like

	do
	{
		delete from TABLE_A
		where processed_i = 1 
		and rownum < 10000;
	
		get the rowcount for the delete
		
	} while (rowcount != 0)

How can I do this in Oracle ? Pls help. Received on Wed Jun 17 1998 - 22:59:26 CDT