amazon-rdslinuxoracleoracle-11g-r2
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.
Just guesswork, but do you select "Upgrade an existing database" early on:
and "advanced install" later on:
The docs do look as if they are referring to the 10g installer.
I think there are at least two generic options for this kind of thing:
Remark: The way Windows handles mapped network drives, it might be that the login session running the DB processes would not see the drive if it was mapped by some other user account. Thus the first option is preferred (maybe also from the pov of dbas?).
Best Answer
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)