Re: SQLLDR with CLOB

Go to technet.oracle.com or tahiti.oracle.com -> Documentation -> Utilities Documentation open pdf or html and then look in Case Studies -> Loading LOBFILES

I could copy - paste that example ... but this way perhaps you realize that the Oracle Manuals are actually very helpful! Wasn't that hard .. was it :)

Anurag

"David" <dfairman16_at_hotmail.com> wrote in message news:b4cefdce.0207292344.54edc40a_at_posting.google.com...
> Hi there. I can't seem to find an example of an SQLLDR control file
> that demonstrates how to load a file into a CLOB column. Has anyone
> done this before and if so can you give me a pointer or two?
>
> For example I have a dummy table defined as
>
> CREATE TABLE tblTest(fileFromCDrive CLOB);
>
> and (forget about other fields) I want to load all files in a specific
> directory into the table (for example all files here c:\testdata\*.*).
>
> Regards
> David
Received on Tue Jul 30 2002 - 19:57:18 CDT