Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQLLDR with CLOB

Re: SQLLDR with CLOB

From: David <dfairman16_at_hotmail.com>
Date: 1 Aug 2002 03:34:26 -0700
Message-ID: <b4cefdce.0208010234.1b74a33f@posting.google.com>


Thank you Anurag. An obvious workaround that didn't occur to me. David

"Anurag" <avdbi_at_hotmail.com> wrote in message news:<ukflb6qhqdf61a_at_corp.supernews.com>...
> 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 Thu Aug 01 2002 - 05:34:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US