Contents

• Title and Copyright Information
• Preface
• 1 What’s New in This Release
  • What’s New in Oracle Data Loader On Demand Guide, Release 42
• 2 Overview of Oracle Data Loader On Demand
  • Overview of Oracle Data Loader On Demand
  • Introduction to Oracle Data Loader On Demand
  • Determining Row ID Support
  • Getting Started with Oracle Data Loader On Demand
  • Software Requirements for Installing Oracle Data Loader On Demand
  • Installing Oracle Data Loader On Demand
  • Which Method Should You Use to Import Records?
    • Downloading Oracle Web Services On Demand Guide
    • Differences Between Using the Import Operation of Oracle CRM On Demand and Oracle Data Loader On Demand
  • What Factors Affect the Processing Speed?
    • About the Enhanced Queuing Mechanism
    • About Throughput Rates
    • What Factors Affect the Throughput Rates?
  • Optimizing Load Size
    • Factors That Affect Performance When Performing a Large Load
• 3 Files, Record Types, and Parameters for Oracle Data Loader On Demand
  • Files, Record Types, and Parameters for Oracle Data Loader On Demand
  • Command-Line Parameters for Oracle Data Loader On Demand
    • Command-Line and Properties File
    • Example of Oracle Data Loader On Demand Command-Line
  • Supported Record Types for Oracle Data Loader On Demand
  • Determining Which Record Types Can Be Imported
  • Data File for Oracle Data Loader On Demand
  • Properties File for Oracle Data Loader On Demand
  • Map File for Oracle Data Loader On Demand
• 4 Using Oracle Data Loader On Demand
  • Using Oracle Data Loader On Demand
  • Insert, Update, and Upsert Parameters
  • Resuming or Halting Operations in Oracle Data Loader On Demand
  • Displaying Information About the Job Status
  • Status Messages from Oracle Data Loader On Demand
  • Guidelines for Using Oracle Data Loader On Demand
    • Use the Required Field Mappings
    • Null Values
    • Use the Supported Date and Time Formats
    • Use the Supported File Formats
    • Make Sure Data Files Are Correct
• 5 Troubleshooting Oracle Data Loader On Demand
  • Troubleshooting Oracle Data Loader On Demand
  • Log Files for Oracle Data Loader On Demand
  • Troubleshooting Oracle Data Loader On Demand
• 6 Sample Files
  • Sample Files
  • Sample Map File
  • Sample Data File
  • Sample Log File