Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: submitting data to oracle
On 2/15/06, Chris Stephens <cstephens16_at_gmail.com> wrote:
>
> submitting the file and storing it as a clob went fairly quickly.
> parsing the xml document into relational tables was taking about 1
>
>
I'm not XML guy, but have you tried DBMS_XMLSAVE to send the XML straight
into rows and columns, as opposed to the clob first approach.
-- Connor McDonald =========================== email: connor_mcdonald_at_yahoo.com web: http://www.oracledba.co.uk "Semper in excremento, sole profundum qui variat" -- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 17 2006 - 07:21:19 CST
![]() |
![]() |