Weaver this doesn't work.
I also tried this
load data
truncate
into table temp
fields terminated by "/"
(col1 ,
col2 ,
col3 ,
col4 ,
col5 ,
col6 ,
col7 ,
col8 ,
col9 ,
col10 ,
col11 ,
col12 ,
col13 ,
col14 ,
col15 ,
col16 ,
col17 ,
col18 ,
col19 ,
col20 terminated by "\"
)
but it doesn't accept "\" it's giving me
SQL*Loader-625: Multibyte character error in control
file. error.
Any ideas...
- "Weaver, Walt" <wweaver_at_rightnowtech.com> wrote:
> Sure. In 8i you can specify the line termination
> string. A typical entry in
> the sqlloadr control file would look like,
>
> INFILE "/your_dir/your_file.csv" "str X'5c0a'"
>
> This specifies where the file containing the data is
> located, and that each
> line is terminated by a "\" (hex 5c) followed by a
> newline (hex 0a). In your
> case, since the whole file is one line, you'd just
> use "str X'5c'", I
> believe.
>
> --Walt
>
> -----Original Message-----
> From: Ashish Shah [mailto:ar_shah_at_yahoo.com]
> Sent: Friday, September 22, 2000 9:50 AM
> To: Weaver, Walt
> Subject: RE: Sqlldr help
>
>
> Hi Weaver,
>
> I have 8i.. could you explain more in "Str...".
>
> Thanks.
>
> --- "Weaver, Walt" <wweaver_at_rightnowtech.com> wrote:
> > What version of Oracle are you on?
> >
> > You can use the 'fields terminated by "/", and if
> > you're on 8i you can use
> > "Str X'5c0a'" on the INFILE line, or somesuch, to
> > specify the line
> > terminator.
> >
> > --Walt Weaver
> > Bozeman, Montana, USA
> >
> > -----Original Message-----
> > From: Ashish Shah [mailto:ar_shah_at_yahoo.com]
> > Sent: Friday, September 22, 2000 9:26 AM
> > To: dbalist; lazydba
> > Subject: Sqlldr help
> >
> >
> > I have file format like below.. it's only big
> line..
> >
> > fields are seperated by '/' and '\' means end of a
> > record.
> >
> > What is the best way to load this file using
> sqlldr.
> >
> >
>
929827081384/QMSL/965821846858#216.10.166.52/1/7775/7775/0/0/0/1077.52499999
> > 5716/USD/965827868940/100/3/F/300////0/1B-
> > -RN-26584356\963404816559/MNKN/965827167
> >
>
777#172.153.170.192/1/850/0/0/0/0/1558.14999999708/USD/965827869212/25/1/F/2
> >
>
5/7/11-13-5-10-30-29-39/$$/0/1-30-9-21-36-19-22-25-7-33-28-0\961264536939/CL
> > SL/9658
> >
>
7770775#63.76.159.204/1/22180/22180/0/0/0/1898.1949999965402/USD/96582786932
> > 8/5/
> >
> >
> > =====
> > Ashish
> > Toronto, Canada
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Send instant messages & get email alerts with
> Yahoo!
> > Messenger.
> > http://im.yahoo.com/
> >
> > --------
> > If you're bored, then visit the list's website:
> > http://www.lazydba.com
> > (updated daily)
> > to unsubscribe, send a blank email to
> > oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to
> oracledba-subscribe_at_quickdoc.co.uk
>
>
> =====
> Ashish
> Toronto, Canada
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo!
> Messenger.
> http://im.yahoo.com/
Ashish
Toronto, Canada
Received on Fri Sep 22 2000 - 12:27:04 CDT