From: "Noah Couture" <noah@coutureconsulting.com>
Subject: ampersand in sql loader data file
Date: 2000/06/06
Message-ID: <xLg%4.3852$v_.406026@nntp2.onemain.com>#1/1
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Complaints-To: abuse@onemain.com
X-Trace: nntp2.onemain.com 960338013 216.26.54.156 (Tue, 06 Jun 2000 20:33:33 EDT)
X-MSMail-Priority: Normal
NNTP-Posting-Date: Tue, 06 Jun 2000 20:33:33 EDT
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.tools


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