SQL Loader in Unix Shell Script Example

SQL Loader in Unix Shell Script Example

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

Here is the SQL Loader shell script example.

#!/bin/ksh

userid="fox"
psw="vinish"
cstring="orcl"

datafilename="/yourdata/abc.csv"
ctlfilename="/yourctl/abc.ctl"
logfilename="/yourlog/sqllog.log"
badlogname="/yourlog/sqlbadlog.log"

sqlldr $userid/$psw@$cstring data=$datafilename errors=1000 control=$ctlfilename log=$logfilename.log bad=$badlogname

result=$?

if [[ $result -eq 0 ]] then
echo 'Data loaded successfully.'
else
echo 'Data load failed.'
fi

exit $result

See also:

  1. SQL Loader Control File Examples
  2. Import Data Using SQL Loader

This Post Has 2 Comments

  1. Shilpa March 10, 2021

    hi
     Write a script to populate the new Timer table from a data file
    (Design decision: spreadsheet or other data file form).

    can u help in this??

    1. Vinish Kapoor March 10, 2021

      Please ask your question with more details on https://orclqa.com

Comments are closed.