Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PROBLEM WITH SQL*LOADER

537341Jan 30 2007 — edited Feb 3 2007
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 3 2007
Added on Jan 30 2007
9 comments
1,637 views