Re: SQL-Loader and special characters

[Quoted] "Nils Appel" <Nils_Appel_at_web.de> wrote in message news:94c74f$8o8$06$1_at_news.t-online.com...
> Hi,
>
> I'm trying to import data that contains a lot of "&" signs and other special
> characters with sql-loader.
>
> To be able to insert such data I need to execute the command "set define
> off" first. The problem is that it seems that one can't define such a
> statement whithin SQL-loader. Also I have no idea how to make the
> set-command last for ever (now I need to execute the "set define off"
> command everytime I log on to SQL+).
>
> Can anyone help me with this?
>
> Tanks.

Also try "set scan off" - not sure if that'll help or not but give it a try.

[Quoted] Not sure if this will work but assuming the '&' is defined in the INIT file for [Quoted] the database, you can also try finding the database's INIT file (probably in [Quoted] $ORACLE_HOME/dbs) and change the '&' to some other special character, like a [Quoted] tilde (~) until you are finished and then change it back again. You will need [Quoted] to bounce the database for each change to take effect.

Or, just change your file to have the & replaced by a tilde and then after you [Quoted] get the data into the database, change it back again.

-Matt Received on Sat Jan 20 2001 - 19:57:41 CET