Import big CSV on Oracle I have big CSV files and placed it on Linux (Amazon AMI). I have installed instant client on Amazon Linux AMI and I can connect to my Oracle database using SQL Plus. How can I import all the CSVs to Oracle from Linux terminal?

My Oracle database is located on Amazon RDS.
Use sql*loader to load the data :

http://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_params.htm#sthref540

(or external tables).

1) setup a .ctl file with your file format

2) setup / point to a receiving table in your database.

3) invoke sql*loader (sqlld)