Home » Infrastructure » Windows » BULK LOAD DATA FROM XML INTO ORACLE .NET (Windows Server 2003, Oracle 10g, .NET 1.1)
BULK LOAD DATA FROM XML INTO ORACLE .NET [message #354332] Fri, 17 October 2008 14:56 Go to next message
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
Re: BULK LOAD DATA FROM XML INTO ORACLE .NET [message #354415 is a reply to message #354332] Sat, 18 October 2008 13:07 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
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.
Re: BULK LOAD DATA FROM XML INTO ORACLE .NET [message #354423 is a reply to message #354415] Sat, 18 October 2008 16:03 Go to previous message
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

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:
  


Current Time: Thu Mar 28 14:28:42 CDT 2024