Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL loader error - LOBFILES

441858Jul 15 2010 — edited Jul 19 2010
Oracle 11gR2 rhel-5 64bit

Hi.

I am trying to do a simple load (1 record) of a LOB (picture/jpeg) and I am getting the following error:


SQLLoader-415: column BLOB_CONTENT in table LOB_TAB cannot use and be the object of an SDF or LOBFILE*


My table looks like this:
SQL> desc lob_tab
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 NAME                                               VARCHAR2(40)
 BLOB_CONTENT                                       BLOB
My .dat file looks like this:

test1,'H:\Hydrangeas.jpg'

My control file looks like this:

LOAD DATA
INFILE 'lobtest.dat'
INTO TABLE lob_tab
FIELDS TERMINATED BY ','
(name char(40),
blob_content LOBFILE(blob_content) TERMINATED BY EOF)

Any idea what I am doing wrong? Is there an easier way to do this possibly?

Thank you all.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2010
Added on Jul 15 2010
2 comments
983 views