This content has been marked as final. Show 5 replies
Use single quotes around the .ctl, .txt and .log files. Like;
Hope That Helps.
sqlldr userid=user/pwd@xyz DATA='test_sql_ldr.txt' CONTROL='test_sql_ldr.ctl' LOG='test_sql_ldr.log'
Do you have multiple ora_homes on your machine?
It may be possible that sqlloader you are calling , into the other orahome then sqlplus.
Try to give full path for sqlloader till bin
Thanks and Regards
I tried your suggestion
But I got same error again ORA-12154
sqlldr userid=user/pwd@xyz DATA='test_sql_ldr.txt' CONTROL='test_sql_ldr.ctl' LOG='test_sql_ldr.log' BAD='test_sql_ldr.bad'
Also, I checked the other thread you mentioned, but still no luck.
I have only one oracle home.
Please let me know how to solve this issue.
Can you try using the PARFILE option ?
Also since you have only one Oracle Home, try skipping the host in the connect string just use "user/password".