Re: SQLLDR with CLOB

David,

The method is pretty similar to one I suggested some while back .... Try this:
http://groups.google.com/groups?q=avdbi+loading&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=OcPj7.10415%24oc.23 73657%40news02.optonline.net&rnum=2

The url above will get wrapped ...

... or search the google groups with search keys: avdbi loading

Anurag

"David" <dfairman16_at_hotmail.com> wrote in message news:b4cefdce.0207310038.38f6434d_at_posting.google.com...
> 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 - 07:17:40 CDT