Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Load XML-File into Oracle
It depends on which way to go. If programming, it's easy to use any XML
parser to generate the loader fiile. I have used Java Xerces or Microsoft
DOM parser. They are quite convenient to use.
However, maybe you can find some good tool to finish the job easily.
"frank kloeck" <frank.kloeck.fk_at_bayer-ag.de> wrote in message
news:a879f21b.0208160710.6306d091_at_posting.google.com...
> Hello,
>
> I want to store big data sets (200000 records and more) into an Oracle
> 8.1.7 database. I want to do it so fast as possible. Actual we do it
> with an oracle Loader file via direct path - this works fine. But the
> data provider switch now to XML. Has anyone experience (examples are
> great) what is the best way to transform XML to a Loader file. Can I
> handle this problem with a XLS style sheet or is a tool or program
> preferable.
>
> Thanks
> Frank
Received on Fri Aug 16 2002 - 16:11:28 CDT