OCI-01652
unable to grow segment_type object_name in tablespace tablespace_name by storage_allocatedstorage_units during operation with SQL ID : sql_id, temp space used by session : string (MB)
- segment_type: The type of the segment that ran into failure. The type may be one of temporary, table, table partition, table subpartition, index, index partition, index subpartition, LOB, LOB partition, or LOB subpartition.
- object_name: The object name if the failure is in an object that is already created.
- tablespace_name: The name of the tablespace that was supposed to be extended during the operation.
- storage_allocated: The number of bytes in KB, MB, or GB in which the allocation was attempted.
- storage_units: The unit of bytes in KB, MB, or GB in which space was allocated.
- sql_id: SQL ID of the session for which error was received.
- Temp Space Allocated: Temporary space currently used by the session.
Cause
In order to execute the operation, additional space is needed in the tablespace but the system is unable to increase the tablespace size. This can happen if the tablespace size is small. In a temporary tablespace, this can also happen because of concurrent use of the tablespace.
Action
If the failure is in a temporary tablespace, then retry the operation in case any concurrent operations have released space. For failure in permanent and temporary tablespaces, the size of the tablespace can be increased using one of the following methods:
- Resize the tablespace using either the ALTER DATABASE RESIZE or ALTER TABLESPACE ADD statement.
- Enable AUTOEXTEND for the tablespace.
- If AUTOEXTEND is already enabled, then:
- If MAXSIZE is set to UNLIMITED, increase the storage media where the tablespace is located.
- Increase MAXSIZE.
- If it is a BIGFILE tablespace, then use the ALTER TABLESPACE
RESIZE statement to increase the tablespace size.