You want to execute the following statements in resumable mode:
CREATE TABLE … AS SELECT
CREATE INDEX
CREATE MATERIALIZED VIEW
Which two methods can be used to enable a session for resumable space allocation? (Choose two.)
A.
Set the RESUMABLE_TIMEOUT initialization parameter to true.
B.
Set the RESUMABLE_TIMEOUT initialization parameter to none.
C.
Execute the ALTER SESSION ENABLE RESUMABLE statement.
D.
Execute the ALTER DATABASE ENABLE RESUMABLE statement.
E.
Set the RESUMABLE_TIMEOUT initialization parameter to a nonzero value.
Explanation:
The default for a new session is resumable mode disabled, unless the RESUMABLE_TIMEOUT initialization parameter is set to a nonzero value.You can enable resumable space allocation system wide and specify a timeout interval by setting the RESUMABLE_TIMEOUT initialization parameter. For example, the following setting of the RESUMABLE_TIMEOUT parameter in the initialization parameter file causes all sessions to initially be enabled for resumable space allocation and sets the timeout period to 1 hour:
RESUMABLE_TIMEOUT = 3600
If this parameter is set to 0, then resumable space allocation is disabled initially for all sessions. This is the default.
A user can enable resumable mode for a session, using the following SQL statement:
ALTER SESSION ENABLE RESUMABLE;
To disable resumable mode, a user issues the following statement:
ALTER SESSION DISABLE RESUMABLE;
REF.: Oracle(r) 10g Administrator Guide, 14-11