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
© Copyright SS64.com 1999-2013
Some rights reserved