What is SQL Loader? Explain the files used by SQL Loader to load file

What is SQL Loader? Explain the files used by SQL Loader to load file.

SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. SQL*Loader supports various load formats, selective loading, and multi-table loads.

When a control file is fed to an SQL*Loader, it writes messages to the log file, bad rows to the bad file and discarded rows to the discard file.

Control file :
The SQL*Loader control file contains information that describes how the data will be loaded. It contains the table name, column datatypes, field delimiters, etc.
controlfile.sql should be used to generate an accurate control file for a given table.

Log File :
The log file contains information about the SQL*loader execution. It should be viewed after each SQL*Loader job is complete
Methods provided by SQL Loader
Methods provided by SQL Loader - Conventional Path Load, Direct Path Load....
What is the physical and logical structure of oracle?
Logical Database structures - Logical structures include tablespaces, schema objects, data blocks, extents and segments.....
Explain how to prevent tablespace fragmentation in oracle.
Tablespace fragmentation can be prevented by using PCTINCREASE command....
Post your comment