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.