ABORT Procedure

This procedure aborts a suspended resumable space allocation. The parameter session_id is the session ID in which the statement is executed. For a parallel DML/DDL, session_id is any session ID that participates in the parallel DML/DDL. This operation is guaranteed to succeed. The procedure can be called either inside or outside of the AFTER SUSPEND trigger.

To call an ABORT procedure, you must be the owner of the session with session_id, have ALTER SYSTEM privileges, or be a DBA.

Syntax

DBMS_RESUMABLE.ABORT (

session_id IN NUMBER);

Parameters

Table 55-2 shows the parameters for the ABORT procedure.

Table 55-2 ABORT Procedure Parameters

Parameter	Description
session_id	The session identifier of the resumable space allocation.