Home » RDBMS Server » Server Utilities » RedHat version Difference (Problem with sqldr) (Oracle Enterprise Edition, 10gR2, RedHat)
RedHat version Difference (Problem with sqldr) [message #329632] Thu, 26 June 2008 02:06 Go to next message
GaneshRamadoss
Messages: 5
Registered: February 2008
Junior Member
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
Re: RedHat version Difference (Problem with sqldr) [message #329646 is a reply to message #329632] Thu, 26 June 2008 02:31 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Because one is version 3 and the other is version 5 and the figure is not the only thing that changes.

By the way, version 3 behaviour was wrong (regarding the standard/usual shell behaviour).

Regards
Michel
Previous Topic: creating export of 9i db from 10g db
Next Topic: Stored Procs Deployment
Goto Forum:
  


Current Time: Tue Dec 24 10:25:26 CST 2024