Oracle Data Loader On Demand Guide > Files, Record Types, and Parameters for Oracle Data Loader On Demand >

Data File for Oracle Data Loader On Demand

The data file contains the records from your external application to be imported or updated into Oracle Data Loader On Demand. The data file is a text file and can be created using any means you prefer (such as exporting data from your application, using a data extraction utility on the external application's database, and so on). The data file must meet the following criteria:

• The data file character set encoding must be specified. If it is not specified, the default value is UTF-8.
• The fields must be separated by either commas (,) or semicolons (;) used consistently. Make sure the properties file specifies which delimiter you use.
• The first line of the data file (the header record) must list the field names to process.
• For each field listed in the header record, there must be an entry in the map file.
• The map file must have the same character set encoding as the data file.
• Every record in the data file must have the same number of fields as the header record.

For an example of a data file, see Sample Data File.