Oracle9i New Feature Series: Resumable Space Allocation
Do you often have issues with batch jobs running out of space producing unable to extent errors in the database? Now Oracle can suspend the session in error until you add more space and resume the session from where it left .
Resumable space allocation solution can be used for the following errors:
The session need to enable the resumable mode using:
ALTER SESSION ENABLE RESUMABLE;
The following views can be queried to obtain information about the status of resumable statements:
To read more: