Click to See Complete Forum and Search --> : Oracle sqlldr


islheg
November 8th, 2006, 06:46 PM
Hi

I want to load data from files into an Oracle DB. I tried to invoke the sqlldr command from a linux machine, but it gave me: command not found. I want to know if anyone has an idea on how to load data from files or what is wrong with the sqlldr command.

islheg

davide++
November 9th, 2006, 05:17 AM
Hi all

Sqlldr is the name of an executable file (it's the program name of SQL Loader).
Probably, when you try to execute it by a command line SQL Loader doesn't work because in your system the PATH variable is not setted correctly. So, you should set PATH right, adding the path where Sqlldir is (usually you can find it in $ORACLE_HOME\bin), or you should run Sqlldr from directory where it is (you must do cd $ORACLE_HOME\bin first).

I hope this will help you.