PROBLEM WITH SQL*LOADER
537341Jan 30 2007 — edited Feb 3 2007Hi to all,
I was having a problem to start SQL*Loader. I did my very best to start it by reading the documentation and some of the help from the people here in the forum but I still having hard time to start SQL*loader. Im using linux/ubuntu. In my operating system prompt I typed "sqlldr"
but it returned a message "bash: sqlldr:command not found". I typed again the command which include userid
" sqlldr handsonxe06/password control=len_ap.ctl log=len_ap.log"
but it returned the messages " bash: sqlldr: command not found". Then I typed another style like this:
"sqlldr /'handsonxe06/password'\ control=len_ap.ctl log=len_ap.log data=len_ap.dat.csv ERRORS=9999 LOAD=2000 DISCARD=toss.dsc, DISCARDMAX=5"
Nothing happened and no message returned but only this sign (>). I dont know what was this all about. It seemed that something was working because this sign (>) was flashing. Can anybody explain to me or help me solved this mystery? Thank you very much. I will be very happy and grateful for some help.
Best regards,
jocelyn