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: