• Arun Kumar

Import csv into database table (SQL* Loader)

Create a table inside database which will be used for rows to import from csv file

SQL> create table student(roll_no number(2), name varchar2(20));

Create a sample csv file at OS level on your database server

# mkdir -p /u02/sql_loader
# cd /u02/sql_loader
# vi load_file.csv

Put some dummy data into the csv file

1,Mukesh
2,Suresh
3,Rajesh

Save the .csv file and close it


Create sql loader control file with .ctl extension

# vi control.ctl

Put below into the control file

LOAD DATA
INFILE 'load_file.csv'
INSERT INTO TABLE student
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
roll_no,
name
)

Invoke the sql loader utility at OS level and start import

# sqlldr userid=system/oracle control=control.ctl log=track.log

6,128 views

Recent Posts

See All

Oracle database refresh is the most common activity in any environment. There are multiple ways to perform the database refresh. Here you will find most common methods that are used for refresh activi