What Is SQL*Loader

Q

What Is SQL*Loader? - Oracle DBA FAQ - Loading and Exporting Data

✍: FYIcenter.com

A

SQL*Loader is a database tool that allows to load data from external files into database tables. SQL*Loader is available as part of the free Oracle 10g Expression Edition. It has some interesting features as:

  • Can load data from multiple data files into multiple tables in one load session.
  • Can specify character set of the data.
  • Can generate sophisticated error reports.
  • Can load data directly to Oracle datafiles, bypassing normal record inserting process.

2007-04-30, 5099👍, 0💬