Re: ampersand in sql loader data file

[Quoted] In article <xLg%4.3852$v_.406026_at_nntp2.onemain.com>,   "Noah Couture" <noah_at_coutureconsulting.com> wrote:
> Hello,
>
> I'm attempting to load a very large (538 million rows) datafile into
 a table
> using sqlloader. I only get about 450 rows into it and then I
 encounter a
> row that contains the much reviled '&' character. I've seen that you
 can
> turn scanning off in sqlplus to avoid this hyperactive interpolation
> feature, but how is this done within the context of sqlldr?
>
> thanks
> noah
>
>

& has no effect on sqlldr. & is a sqlplus'ism -- sqlldr does not do "&", it is not the problem.

Whats the error you are getting?

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://osi.oracle.com/~tkyte/index.html
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.