What is a SQL*Loader Control File?

<<Previous  Next>>

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

What is a SQL*Loader Control File?

A SQL*Loader control file contains the following specification:

• Location of the input data file.
• The format of the input date file.
• The target table where the data should be loaded.
• The way input data fields should be mapped to target table columns.
• Select criteria to select input records for loading.
• Location where the errors should be reported.  .

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 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...........

<<Previous  Next>>

Write your comment - Share Knowledge and Experience