My Oracle Support Banner

Using RESUMABLE Session to Avoid Transaction Abort Due to Space Errors (Doc ID 136941.1)

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This document explains the cases when the resumable space allocation feature can be useful.
In case a transaction is suspended for space allocation reasons,the resumable space allocation feature allows the transaction to be resumed.

Scope

 These are very common situations when a transaction is interrupted for a space allocation issue:

  * storage settings inappropriate for the table being inserted
  * storage settings inappropriate for the rollback segment being used for the transaction
  * lack of space on temporary tablespace
  * user quotas restricted
  * users privileges missing

The resumable statement feature allows the DBA, once having applied the appropriate solution to the space allocation issue, to resume the suspended
transaction which does not loose all the work done previously.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.