• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Database » sql loader in oracle

sql loader in oracle

September 11, 2022 by techgoeasy Leave a Comment

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

Filed Under: Oracle, Oracle Database

Reader Interactions

Leave a Reply Cancel reply

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

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to generate sql monitor report in Oracle
  • How to find the long running (longops session) in Oracle
  • How to find concurrent request id from Sid or spid
  • how to check recycle bin in oracle: Purge, enable/disable
  • how to check fra size in oracle: Location, usage, change size

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us