Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_RESUMABLE, 2 of 7
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.
DBMS_RESUMABLE.ABORT (session_id IN NUMBER);
Table 55-2 shows the parameters for the ABORT
procedure.
Parameter | Description |
---|---|
|
The session identifier of the resumable space allocation. |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|