Help - Search - Members - Calendar
Full Version: RedHat version Difference (Problem with sqldr)
Oracle DBA Forums > Oracle > Oracle Forum
GaneshRamadoss
Hi we have problem when using sqlldr in redhat version.

In red hat version 3 the below command works fine

$ sqlldr control=./filookup.ctl userid=perf73b4prv6_user/outback@qarac log=./abalog.txt bad=./ababad.txt silent=(HEADER,FEEDBACK)

But the same command in Redhat version 5 is giving some problem

Error Message :

-bash: syntax error near unexpected token `('

We tried using escape character as below in redhat 5

$ sqlldr control=./filookup.ctl userid=perf73b4prv6_user/outback@qarac log=./abalog.txt bad=./ababad.txt silent=\(HEADER,FEEDBACK\)

it went thro successfully.

The same works well in redhat 3 without escape character, but not in redhat 5 , why is that

Thanks

Ganesh R
burleson
Hi Ganesh,

>> But the same command in Redhat version 5 is giving some problem

Could it be an environmental variable setting?

*******************************************************************
>> The same works well in redhat 3 without escape character, but not in redhat 5 , why is that?

Because Red Hat changes their code between releases! They all want thrir shells to be the best!

Red Hat is all open source, check bash and see.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.