Oracle Data Loader On Demand Guide > Using Oracle Data Loader On Demand >

Resuming or Halting Operations in Oracle Data Loader On Demand


This topic describes how to halt or resume operations in Oracle Data Loader On Demand.

You can halt Oracle Data Loader On Demand by pressing CTRL+C. This halts the process of submission of the remaining records in the data file. All records that have been submitted continue to be processed by the server. To resume processing, create a properties file using the parameters specified in Table 4. To stop requests on the server, log in to Oracle CRM On Demand, navigate to the Import Queue and cancel the request.

To halt operations in Oracle Data Loader On Demand

  • Press CTRL+C.

This halts the process of submission of the remaining records in the data file. All records that have been submitted continue to be processed by the server.

The following procedure describes how to obtain the request ID of a previously interrupted request.

To obtain a request ID

  1. Navigate to the folder where the log files were stored.

    The log files are saved at the location specified with the -clientlogfiledir parameter.

  2. Open the last log file and navigate to the bottom of the file.

    A message displays the request ID similar to the following:

    To resubmit ... please re-execute ... using the RESUME option while providing the following Request ID

The following procedure describes how to resume operations in Oracle Data Loader On Demand.

To resume operations in Oracle Data Loader On Demand

  • Create a properties file using the required or optional parameters.

    For more information on the required or optional parameters, see Table 4.

Table 4 lists the Resume parameters for Oracle Data Loader On Demand.

Table 4. Resume Parameters for Oracle Data Loader On Demand
Parameter
Required or Optional
Description

-resumerequest value

Required

Request ID of the import request that you want to resume.

-waitforcompletion

Optional

When specified, you get a prompt if:

  • The processing of the request is complete with a status of Completed.
  • You press CTRL+C.
Oracle Data Loader On Demand Guide, Release 37 Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.