SQL Loader - Oracle 10g/11g Data and Database Management Utilities - page 50

In this second example, the operator will launch SQL*Loader, this time with the
RESUMABLE feature enabled. In order for the user to use the resumable feature, it
must have the RESUMABLE privilege granted.
$ sqlplus / as sysdba
SQL> grant RESUMABLE to SQLLDRDEMO;
Grant succeeded.
Let the load begin, and this time use the keywords:
• resumable : This keyword enables the RESUMABLE feature; by default its value
is FALSE.
• resumable_name : This declares what the name of the resumable identifier
will be; displayed at the DBA_RESUMABLE view.
• resumable_timeout : This is the time to wait in case an outstanding issue
arises. The operator must detect, diagnose, and correct the problem before
this time expires. By default it waits 7,200 seconds.
In this example the command line used was:
$ sqlldr sqlldrdemo/oracle resumable=true resumable_name=ABC_LOAD
resumable_timeout=300 direct=true control=abc
Here, the resumable keyword was defined as true, a name is used to identify the
resumable event and a 5 minute time out was declared. In this scenario an operator
has to identify the problem by querying the DBA_RESUMABLE view; once identified, fix
the problem and let the resumable feature exit on its own from the suspend mode to
successfully finish the load.