Re: Bulk Updates in Oracle Database

#1

rayoflight_kiran (AT) yahoo (DOT) com (Kiran Dalvi) wrote in message news:<b33f94a.0312150005.26589d6f (AT) posting (DOT) google.com>...

Quote:

Hi,
I am getting the data in XML file format. The amount of data is
huge.
I want to parse the XML (in Java) and ctreate Data Objects (DOs) out
of it.
Number of such DOs is typically around 30000+ Thus now I want to
add the information in these DOs into Database. In other words, I want
to insert 30000+ rows in Database.
Let me know how it can be done efficiently. I know the conventional
methods like INSERT or SELECT FOR UPDATE.
In short, I want to update this bulk data into Database at a shot.
I am using Java as a programming language. So I guess, options related
to scripting are not feasible. (In my Opinion)

let's see, you want
bulk loading into ORACLE
only using JAVA

You may be out of luck, but to be sure, I'd suggest you ask this in
one of the ORACLE groups. I'm not sure which group is most appropriate
for this question:
comp.databases.oracle.server
comp.databases.oracle.tools
comp.databases.oracle.misc

Try c.d.o.tools
And don't forget to mention WHICH version of ORACLE. There are
solutions that are available in some versions but not in others.

HTH.
ed

#2

Kiran Dalvi wrote:

Quote:

Hi,
I am getting the data in XML file format. The amount of data is
huge.
I want to parse the XML (in Java) and ctreate Data Objects (DOs) out
of it.
Number of such DOs is typically around 30000+ Thus now I want to
add the information in these DOs into Database. In other words, I want
to insert 30000+ rows in Database.
Let me know how it can be done efficiently. I know the conventional
methods like INSERT or SELECT FOR UPDATE.
In short, I want to update this bulk data into Database at a shot.
I am using Java as a programming language. So I guess, options related
to scripting are not feasible. (In my Opinion)

Look into using Oracle's SQL*Loader utility package. It should be able
to load 30,000 rows in under a minute.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Bulk Updates in Oracle Database

comp.databases comp.databases

Re: Bulk Updates in Oracle Database - 12-15-2003 , 01:42 PM

Re: Bulk Updates in Oracle Database - 12-15-2003 , 10:24 PM