SPACE_ERROR_INFO Function

This function looks for space-related errors in the error stack. If it cannot find a space related error, it will return FALSE. Otherwise, TRUE is returned and information about the particular object that causes the space error is returned.

Syntax

DBMS_RESUMABLE.SPACE_ERROR_INFO

error_type        OUT VARCHAR2, 
object_type       OUT VARCHAR2, 
object_owner      OUT VARCHAR2, 
table_space_name  OUT VARCHAR2, 
object_name       OUT VARCHAR2, 
sub_object_name   OUT VARCHAR2) 

return boolean;

Parameters

Table 55-6 SPACE_ERROR_INFO Function Parameters

Parameter	Description
error_type	The space error type. It will be one of the following: NO MORE SPACE MAX EXTENTS REACHED SPACE QUOTA EXCEEDED
object_type	The object type. It will be one of the following: TABLE SPACE ROLLBACK SEGMENT UNDO SEGMENT TABLE INDEX CLUSTER TEMP SEGMENT INDEX PARTITION TABLE PARTITION LOB SEGMENT TABLE SUBPARTITION INDEX SUBPARTITION LOB SUBPARTITION
object_owner	The owner of the object. NULL if it cannot be determined.
table_space_name	The table space where the object resides. NULL if it cannot be determined.
object_name	The name of rollback segment, temp segment, table, index, or cluster.
sub_object_name	The partition name or sub-partition name of LOB, TABLE, or INDEX. NULL if it cannot be determined.