OraFAQ Forum: Windows » BULK LOAD DATA FROM XML INTO ORACLE .NET

Home » Infrastructure » Windows » BULK LOAD DATA FROM XML INTO ORACLE .NET (Windows Server 2003, Oracle 10g, .NET 1.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

BULK LOAD DATA FROM XML INTO ORACLE .NET [message #354332]

Fri, 17 October 2008 14:56

manojsanthi
Messages: 2
Registered: October 2008

Junior Member

Hi All,

I would like to know if there is a way to Bulk Upload Data from either a Flat file (text file) or XML into Oracle Database.
I am talking about close to 100,000 rows. So I want to avoid an insert statements in a ForEach Loop kind of solution which creates a lot of Network traffic. Also, will going the way of using ODP.NET put too much load on the memory and cause performance degradation of other App running in the same server?
I want to implement this in Windows Server 2003 using .NET platform.
Server Specs: Intel Xeon CPU 2.80 GHz and 2 GB RAM.

Thanks for any answers,
-Manoj

Report message to a moderator

Re: BULK LOAD DATA FROM XML INTO ORACLE .NET [message #354415 is a reply to message #354332]

Sat, 18 October 2008 13:07

Barbara Boehmer
Messages: 9102
Registered: November 2002
Location: California, USA

Senior Member

You can load data from a flat file, either delimited or fixed position, into Oracle tables using either SQL*Loader or external tables. Information, syntax, and examples for both are available in the online documentation.

Report message to a moderator

Re: BULK LOAD DATA FROM XML INTO ORACLE .NET [message #354423 is a reply to message #354415]

Sat, 18 October 2008 16:03

manojsanthi
Messages: 2
Registered: October 2008

Junior Member

Hi Barbara Boehmer,

Thanks for the reply.
I found 3 links explaining how to load using Sql*Loader from .Net application.

http://www.orafaq.com/wiki/SQL*Loader_FAQ
http://blogs.msdn.com/csharpfaq/archive/2004/06/01/146375.aspx
http://support.microsoft.com/default.aspx?scid=kb;en-us;555134

Report message to a moderator

Previous Topic:	Disk Utilization for 0 C: D: is 646.39%, crossed warning (80) or critical (95) threshold
Next Topic:	Migrating 10g r1 server from os windows 2000- 2003

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 20 19:43:03 CST 2025