install oracle sqlloader on centos 7

nickollas Oracle

1 – Download Basic Package and Tools Package – Includes SQL*Loader from:
https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

2 – Install rpm packages

yum install oracle-instantclient18.3-basic-18.3.0.0.0-1.x86_64.rpm
yum install oracle-instantclient18.3-tools-18.3.0.0.0-1.x86_64.rpm

3 – Configure environment variables create a file /etc/profile.d/oracle.sh

vi /etc/profile.d/oracle.sh

export LD_LIBRARY_PATH=/usr/lib/oracle/18.3/client64/lib:$LD_LIBRARY_PATH
export PATH=/usr/lib/oracle/18.3/client64/bin:$PATH

4 – Update environment variables

source /etc/profile.d/oracle.sh

5 – Create a loader file

vi loader_file.ctl

load data
  infile "/tmp/data_file
  append
  into table People
  fields terminated by '|'
  TRAILING NULLCOLS
  ( id, name, countries, age )

* /tmp/data_file content sample:

1|nickollas|brasil,portugal|34
2|carlos|portugal,japan|39

6 – Connect to oracle server with sql loader and execute the loader file

sqlldr user/password@hostname:port/service_name control=loader_file.ctl

Leave a comment