OraFAQ Forum: Unix » SQL Loader Issue

Home » Infrastructure » Unix » SQL Loader Issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Loader Issue [message #654746]

Thu, 11 August 2016 10:45

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?

Report message to a moderator

Re: SQL Loader Issue [message #654748 is a reply to message #654746]

Thu, 11 August 2016 10:54

BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal

Senior Member

"testing load.csv" should work OK

Report message to a moderator

Re: SQL Loader Issue [message #654749 is a reply to message #654748]

Thu, 11 August 2016 10:58

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

Report message to a moderator

Re: SQL Loader Issue [message #654750 is a reply to message #654749]

Thu, 11 August 2016 11:10

Prc86
Messages: 6
Registered: August 2016

Junior Member

Can anyone help who has executed sqlldr inside a unix script?

Report message to a moderator

Re: SQL Loader Issue [message #654751 is a reply to message #654750]

Thu, 11 August 2016 11:15

BlackSwan
Messages: 26757
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.

Report message to a moderator

Re: SQL Loader Issue [message #654752 is a reply to message #654751]

Thu, 11 August 2016 11:26

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

Report message to a moderator

Re: SQL Loader Issue [message #654753 is a reply to message #654752]

Thu, 11 August 2016 11:27

Prc86
Messages: 6
Registered: August 2016

Junior Member

Thank you for your rude response Black swan

Report message to a moderator

Re: SQL Loader Issue [message #654755 is a reply to message #654753]

Thu, 11 August 2016 11:35

BlackSwan
Messages: 26757
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.

Report message to a moderator