Oracle provides a means for suspending, and later resuming, the execution of large
database operations in the event of space allocation failures. This enables an
administrator to take corrective action, instead of the Oracle database server returning
an error to the user. After the error condition is corrected, the suspended operation
A statement runs in a resumable mode only when the client explicitly enables
resumable semantics for the session using the ALTER SESSION statement.
Resumable space allocation is suspended when one of the following conditions occur:
■ Out of space condition
■ Maximum extents reached condition
■ Space quota exceeded condition
For nonresumable space allocation, these conditions result in errors and the statement
is rolled back.
Suspending a statement automatically results in suspending the transaction. Thus all
transactional resources are held through a statement suspend and resume.
When the error condition disappears (for example, as a result of user intervention or
perhaps sort space released by other queries), the suspended statement automatically
1. 将操作悬挂 , 待管理员改正错误后 , 悬挂的操作继续执行
2. 可以通过 ALTER SESSION ENABLE RESUMABLE 来使用该模式
3. 当空间不够 , 达到最大区数目 , 超过空间配额限制时 , Resumable space allocation is suspended.
错误消失时 , 悬挂的语句自动恢复
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-980849/，如需转载，请注明出处，否则将追究法律责任。