I am trying to delete some records from a table and it takes a few hours to finish the process. However, I always ended with the following error:
ORA-01562: failed to extend rollback segment number 12
ORA-01628: max # extents (121) reached for rollback segment R012
The rollback segment is always different when I execute the sql. I have tried to extend the rollback segment already. May I know if I can create a rollback segment and delete the records using that rollback segment only? After finishing the deletion, I will remove the rollback segment. Is this possible? If not which rollback segment maxextents should I increase? Thanks!
Click Here to Expand Forum to Full Width