How to Install SQL Loader on Linux?

Using SQL Loader, data from external files are loaded into Oracle database tables. Its robust data parsing engine imposes few restrictions on the data file’s format. SQL loader can load data from multiple data files in the same load session. Using SQL functions, data can be manipulated before loading it. Let’s learn how to install SQL loader in Linux operating system. 

How to Install SQL Loader in Linux

Step 1: Download the Oracle Instant Client using wget utility.

wget “https://download.oracle.com/otn_software/linux/instantclient/214000/instantclient-tools-linux.x64-21.4.0.0.0dbru.zip”

Once the downloading of the package to be installed is completed, it is ready to be extracted and installed. After downloading this compressed file, considering that the file is downloaded in Downloads, we will extract those files there.

Step 2: Navigate to the directory where the package is installed and unzip the files as given commands.

cd Downloads

sudo unzip instantclient-tools-linux.x64-21.4.0.0.0dbru.zip -d /opt/oracle/

The file is extracted.

Step 3: Search the file named sqlldr with the given command.

find / -iname sqlldr

Step 4: Ensure the presence of sqlldr at the defined location.

cd /home/kali/Downloads/instantclient_21_4 

Step 5: List the contents in detail to see the sqlldr.

ls -l

This way, our sqlldr is present in that directory as we needed for the SQL loader installation.