Home » Oracle » Oracle Database » sql loader in oracle

sql loader in oracle

In this post, we will learn about sql loader in oracle, SQL loader syntax in oracle, SQL loader direct path load, SQL loader examples

Sql Loader in Oracle

  • This tool is used to move the data from Non –oracle standard source or external files into the oracle
  • we can Load data from multiple data files
  • we can load data to multiple tables
  • we can use conventional load or direct path load which provides superior loading performance
  • we can use SQL loader from a system other than the database server

How Sql loader works

Two types of input have to be provided to SQL*Loader.

  • The data file containing the actual data
  • The control file containing the specification which drives the sql*loader session

SQL Loader generates three files

  • The log file         (Summary of the execution of the Load)
  • The bad File        (Records which are Rejected by Oracle either the format is wrong or the database rejected it)
  • The discard File  (Records were filtered out of the load because they did not match any record-selection criteria specified in the control file.)
sql loader in oracle

Sql loader Syntax

Syntax

sqlldr keyword=value

Example

SQLLDR CONTROL=load.ctl, LOG=load.log, BAD=load.bad, DATA=load.dat
USERID=scott/tiger, DISCARD=load.dsc,

Hope you like this content on sql loader in oracle

Related Articles
LEAD Function in Oracle
DENSE function in Oracle
Oracle LISTAGG Function
Aggregating Data Using Group Functions
https://docs.oracle.com/cd/E11882_01/server.112/e41084/functions004.htm

See also  Oracle sql: order by and distinct clause

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top