From 9i, you can run long running operations/processes that run out of space, using RESUME feature. Basically, the transaction runs in resumable mode and if there are any space issues, the transaction will not fail. It will be suspended until the problem is fixed and will resume automatically after the space is available.
You will need to grant resumable to user, before the user can start a session in resumable mode
Examples:
Altering the session to resumable mode
Grant RESUMABLE to user1;
Alter session enable resumable timeout 3600 name ‘SPACE-ISSUE’;
Disabling resumable
Alter session disable resumable;
Monitoring the suspended sessions :
You can query dba_resumable view to monitor any suspended transactions.
SELECT * FROM dba_resumable;
