-datafilepath value

Required

The full path (including the file name) of the data file that you want to import.

-mapfilepath value

Required

The full path (including the file name) of the map file.

-recordtype value

Required

Record type of the data that you want to import. For a list of supported record types, see Supported Record Types for Oracle Data Loader On Demand.

-duplicatecheckoption value

Optional

Duplicate check option. Use this parameter only for Update and Upsert operations. Use this parameter to specify which field Oracle Data Loader On Demand uses to check records to determine whether the record is a duplicate. The value must be one of the following:

• externalid. This is the default value.
• rowid

If you specify this parameter for an Insert operation, it is ignored. No duplicate checking occurs, and it does not cause an error or warning.

-datetimeformat value

Optional

Date and time format. The date and time formats for this selection are listed in Table 7.

-csvdelimiter value

Optional

CSV delimiter used in the data file. The value must be one of the following:

• , (comma). This is the default value. This delimiter applies to the data file only; it is not used for the map file or properties file.
• ; (semicolon)

-importloglevel value

Optional

Specify the error level of the log file. The value must be one of the following:

• all. Lists all error messages.
• errorswarnings. Lists error and warning messages only.
• errors. Lists error messages only. This is the default value. This setting is for Insert, Update, and Upsert operations on the server.

For troubleshooting tasks, you can increase the log level to all, which records all detailed error messages. However, the all error level slows down an operation.

-waitforcompletion

Optional

When specified, Oracle Data Loader On Demand displays a status message if the processing of the request finishes with a status of Completed.

When specified, if you press CTRL+C , then Oracle Data Loader On Demand prompts you to continue processing or cancel.

- disableemailnotification

Optional

Specifies whether an email notification is sent after a database import. If this parameter is not in the parameter list, then the email notification is sent after the database import. If this parameter is in the parameter list, then the email notification is not sent.

- senduserlogfile

Optional

Specifies whether Oracle Data Loader On Demand sends the user log file after a database import. If disableemailnotification is in the parameter list, then the value of senduserlogfile is ignored.

NOTE:  If the user log file size exceeds 20 MB, then Oracle Data Loader On Demand does not email the file, but does note this fact in the user log file. Refer to the userlogfiledir parameter to specify where the user log file is stored.

- userlogfiledir value

Optional

Specifies the directory in which to save the user log file. If you do not use -userlogfiledir to specify a directory and the -waitforcompletion parameter is present in the properties file, then the user log file is stored in the same directory as the Oracle_DataLoader_OnDemand.jar file. If neither the -userlogfiledir parameter or the
-waitforcompletion parameter are specified, then the user log file is not saved.