Home » Infrastructure » Unix » SQL Loader Issue
SQL Loader Issue [message #654746] Thu, 11 August 2016 10:45 Go to next message
Prc86
Messages: 6
Registered: August 2016
Junior Member
I have a Unix script in which data is loaded from a csv to a database table.
The csv file name is of the format
testing load.csv ( There is a white space character in between the file name)
As a result the log file has captured the error as cannot open file load.cab.
File not found.

I believe removing the white space character will resolve the issue .
Can anyone please confirm?
Re: SQL Loader Issue [message #654748 is a reply to message #654746] Thu, 11 August 2016 10:54 Go to previous messageGo to next message
BlackSwan
Messages: 25745
Registered: January 2009
Location: SoCal
Senior Member
"testing load.csv" should work OK
Re: SQL Loader Issue [message #654749 is a reply to message #654748] Thu, 11 August 2016 10:58 Go to previous messageGo to next message
Prc86
Messages: 6
Registered: August 2016
Junior Member
Testing load.csv runs ok when sqlldr is executed... but my sqlldr is executed inside a Unix script
Re: SQL Loader Issue [message #654750 is a reply to message #654749] Thu, 11 August 2016 11:10 Go to previous messageGo to next message
Prc86
Messages: 6
Registered: August 2016
Junior Member
Can anyone help who has executed sqlldr inside a unix script?
Re: SQL Loader Issue [message #654751 is a reply to message #654750] Thu, 11 August 2016 11:15 Go to previous messageGo to next message
BlackSwan
Messages: 25745
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

It is NOT possible to say what you do wrong when you do NOT actually show us what you do & how Oracle responds.

It appears that you don't know Oracle & you don't know *NIX.
Re: SQL Loader Issue [message #654752 is a reply to message #654751] Thu, 11 August 2016 11:26 Go to previous messageGo to next message
Prc86
Messages: 6
Registered: August 2016
Junior Member
Testing load.csv runs ok when sqlldr is executed... but my sqlldr is executed inside a Unix script
Re: SQL Loader Issue [message #654753 is a reply to message #654752] Thu, 11 August 2016 11:27 Go to previous messageGo to next message
Prc86
Messages: 6
Registered: August 2016
Junior Member
Thank you for your rude response Black swan
Re: SQL Loader Issue [message #654755 is a reply to message #654753] Thu, 11 August 2016 11:35 Go to previous messageGo to next message
BlackSwan
Messages: 25745
Registered: January 2009
Location: SoCal
Senior Member
ISSUE?
What issue?
Nothing you have posted in this thread shows any problem.

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide

It is NOT possible to say what you do wrong when you do NOT actually show us what you do & how Oracle responds.
Re: SQL Loader Issue [message #654757 is a reply to message #654752] Thu, 11 August 2016 11:46 Go to previous messageGo to next message
Michel Cadot
Messages: 65252
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Write 'Testing load.csv', with quotes, in Unix script.
Note that it is hard to debug a script we don't see.

Re: SQL Loader Issue [message #654758 is a reply to message #654757] Thu, 11 August 2016 12:06 Go to previous message
Prc86
Messages: 6
Registered: August 2016
Junior Member
Thank you Michel.
Your response really helped.
Previous Topic: Software for oracle 11.2.0.4 enterprise edition 32 bit on solaris sparc
Next Topic: ./dbstart: test: argument expected
Goto Forum:
  


Current Time: Wed Dec 13 03:37:11 CST 2017

Total time taken to generate the page: 0.09951 seconds