Re: SQLLDR with CLOB

I looked at the Oracle technet documentation in the first instance and couldn't see anything.

Looking at it again I still can't see an example, or even hint, on how to load all files with a specific wildcard; the examples quoted in these documents are for specific qualified filenames. David

> 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

>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 Wed Jul 31 2002 - 03:38:32 CDT