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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: submitting data to oracle

Re: submitting data to oracle

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Fri, 17 Feb 2006 21:21:19 +0800
Message-ID: <5e3048620602170521ob0fea26kd94ed0c6fe3f4af6@mail.gmail.com>


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-l
Received on Fri Feb 17 2006 - 07:21:19 CST

Original text of this message

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