Oracle: Import CSV file unix

Question

i want to import csv file into oracle database using pl / sql developer, i inform you that the base is installed under linux, and pl / sql under windows, i ran the command:

SQL> @C:\app\session_name\product\11.2.0\client_3\BIN\sqlldr user/passwd@base_name  control=/opt/FNDBSS/Control/FNControl.txt log=log.txt;

but the error has appeared: Error reading file

thank you for helping me

Your control file is pointing to Linux path - /opt/FNDBSS/Control/FNControl.txt and you are executing sqlldr in Windows. You should either have a local control file or run it in Linux command prompt. — Kaushik Nayak
– Kaushik Nayak, Commented Dec 3, 2017 at 12:44
Thanks, but in PL/SQL i connected to database installed in Linux system — Zerimeche Khaled
– Zerimeche Khaled, Commented Dec 3, 2017 at 13:46
@KaushikNayak seems to be suggesting you copy the FNControl.txt file to windows where you are running sqlldr (and give the correct path to it in your pl/sql command). Did you try that? — ysth
– ysth, Commented Dec 3, 2017 at 21:38
SQL> @C:\app\session_name\product\11.2.0\client_3\BIN\sqlldr user/passwd control=C:\TEST\Control2.ctl, DATA=C:\TEST\test2.csv Error reading file — Zerimeche Khaled
– Zerimeche Khaled, Commented Dec 5, 2017 at 9:16

Belayer · Accepted Answer · 2017-12-10 18:48:57Z

1

A the least add the LOG file to the command line or your control file. It tells you what loader is doing and perhaps why. Additionally check into the BAD and DISCARD files. See the SQL Loader concepts for your Oracle version.

answered Dec 10, 2017 at 18:48

Belayer

15.1k2 gold badges13 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle: Import CSV file unix

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related