Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLLDR loading BLOBS
Problem: file may contain up to 200k records Problem2: how do you delimit a JPEG as it contains
any possible delimiter
Problem3: Oracle does not support blob loads below 8i
Any other thoughts???
In article <8oh6vm$g2q$1_at_news.sinet.slb.com>,
"Yong Huang" <yhuang_at_indigopool.com> wrote:
> Here's my sqlldr control file:
>
> LOAD DATA
> INFILE 'loadfile.dat'
> append
> INTO TABLE file_attachment
> FIELDS TERMINATED BY ','
> (object_id integer external,
> object_type_id integer external,
> section_id integer external,
> section_sequence_no integer external,
> file_descr char,
> file_name char,
> file_type char,
> file_size_bytes integer external,
> attachment_file LOBFILE(file_name) TERMINATED BY EOF)
>
> and my loadfile.dat is:
>
> 3,5,169,1,,_7_bkgrnd3.jpg,jpg,25306,_7_bkgrnd3.jpg,
> ...
>
> My jpg files are in the current directory.
>
> Yong Huang
> yhuang_at_indigopool.com
>
> <don_leclaire_at_my-deja.com> wrote in message
> news:8oeu7h$gv6$1_at_nnrp1.deja.com...
> > I am trying to load a variable length JPEG's
> > into an Oracle 8i database using SQLLDR, these are
> > coming from a flat file and I need to know if anyone has
> > completed this..
> >
> > I need to know how to do this or if the JPEG format has a
> > reserve character that I can delimit with
> >
> > Or is it possible to use a multiple character delimiter
> >
> > HELP HELP HELP!!!!!!!
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Aug 30 2000 - 15:12:14 CDT