I´m trying to execute this query into a SP
DELETE FROM table SC WHERE SC.evaluationMonth= 'Some month'; COMMIT;
But for this month there are something like 10 million records. So I get the error
ORA-01562: failed to extend rollback segment number 11.
How can I improve the SP or make something to solve this problem?
Pdta: I had increase de unto to 20G