What is SQL*Loader?

SQL*Loader is a loader utility used for moving data from external files into the Oracle database in bulk. It is used for high performance data loads.

Oracle - What is SQL*Loader? - April 10, 2009 at 11:00 AM

What is SQL*Loader?  

It is a database tool that allows data to be loaded from external files into database tables.
It is available as part of the free Oracle 10g Expression Edition.

Features:

• Capability of loading data from multiple data files into multiple tables in a single session.
• Specification of the character set of data.
• Sophisticated error report generation.
• Capabilities of loading data directly to Oracle datafiles using the normal insert process.

What is SQL loader? What are the files used by SQL Loader? Explain the method of loading data.

Answer
SQL Loader loads data from external files into tables in oracle. SQL loader uses following files

Method for loading data
Connectional path load
Direct Path load 

Also read

What is the difference between the SQL*Loader and IMPORT utilities?

SQL*Loader can be used to load data from Delimiter separated files and fixed............

Oracle Import export

What are the use of Export and Import command?, What are the parameters to be provided while executing Export and Import commands?, What is the difference between the SQL*Loader and IMPORT utilities?..............

What is a SQL*Loader Control File?

A SQL*Loader control file contains the following specification: location of the input data file, format of the input date file, target table where the data should be loaded.............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience