PL/SQL Packages DBMS_RESUMABLE

Allows you to suspend large operations that run out of space (or reach space limit) after executing for a long time, fix the problem, and make the statement resume execution.

Subprocedures:

ABORT                Abort a suspended resumable space allocation. 

GET_SESSION_TIMEOUT Function
                     Get the current timeout value of the resumable space allocations
                     for a session with session_id. 

SET_SESSION_TIMEOUT  Set the timeout of resumable space allocations 
                     for a session with session_id. 

GET_TIMEOUT Function
                     Get the current timeout value of resumable space allocations
                     for the current session. 

SET_TIMEOUT          Set the timeout of resumable space allocations
                     for the current session. 

SPACE_ERROR_INFO Function
                     Look for space-related errors in the error stack.
                     If it cannot find a space-related error, it will return FALSE.  

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al

Related Commands:

Related Packages: