December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_RESUMABLE.ABORT
(session_id IN NUMBER);
Aborts the suspended session_id.
FUNCTION DBMS_RESUMABLE.GET_SESSION_TIMEOUT
(session_id IN NUMBER);
Returns the timeout value of resumable space allocations for session_id.
FUNCTION DBMS_RESUMABLE.GET_SESSION_TIMEOUT
(session_id IN NUMBER,
timeout IN NUMBER);
Sets timeout for resumable space allocations for session_id.
FUNCTION DBMS_RESUMABLE.GET_TIMEOUT;
Returns the timeout value of the current session.
PROCEDURE DBMS_RESUMABLE.SET_TIMEOUT
(timeout IN NUMBER);
Sets timeout of the current session.
FUNCTION 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;
If there is a space-related error, returns information in parameters and TRUE for the function; otherwise, returns FALSE.