Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Escape sequences in SQL*Loader

Re: Escape sequences in SQL*Loader

From: Morten Myrvold <someone_at_somwehere.no>
Date: 1997/12/03
Message-ID: <6633gv$5tv$1@elle.eunet.no>#1/1

Billy Verreynne wrote in message <662uu5$bri$1_at_hermes.is.co.za>...
>The only way (other than replacing CR's before loading) is to make use of
>the FIX option in SQL*Loader (don't think it's clearly documented in the
>Server Utils manual).
>
>If you specify a fix record length, SQL*Loader ignores CR's and read the
>specified fix length number of bytes as a record.
>
>Eg.
>LOAD DATA
>INFILE 'foo.dat' "FIX 153"
>APPEND INTO
>TABLE scott.foo
>(
> col1 position(001:010),
> col2 position(011:099),
> etc..
>)
>
>Of course if the datafile has a variable record length format, this will
 not
>work.
>
>regards,
>Billy
>
>

Exactly, and since my file *does* contain variable length records, I'm outta luck (again).....

Does anyone have a solution .... pleeeeeeaseeee??? (This is bugging the h... out of me, and seeing as we've got a project deadline to meet as well - that certainly doesn't make things any easier... B;-) Received on Wed Dec 03 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US