SqlBulkCopy and Oracle?

From: Elton Wang (elton_at_discussions.microsoft.com)
Date: 12/24/04 

Date: Fri, 24 Dec 2004 13:46:01 -0800

In Sql-server, there are bcp utilities to accommodate
insert multi-rows data from data file into database. So
even in ADO.NET 1.1 without SqlBulkCopy class, we are
using StringBuilder to create data file, then use Bulk
Insert to save data into the database. Compare to looping
though each row insert, it's much faster. I suppose in
Oracle, there are similar utilities to accommodate bulk
insert.

Elton Wang
elton_wang@hotmail.com

>-----Original Message-----
>I have read a little about the new SqlBulkCopy in ADO.NET
2.0. It
>sounds like it's exactly what I need. However... is
there an
>equivalent for Oracle?
>
>What I'm looking for is the fastest way to get 100,000+
records into
>an Oracle database from a dataset. I'm very open to
suggestions.
>Presently we are looking at exporting from the dataset to
a CSV and
>then doing an external table mount from Oracle. Are
there any better
>ways?
>
>Thanks!
>Brad.
>.
>

Relevant Pages

  • Tru64 5.1 System hangs when creating Oracle data file > 1Gb - any suggestions on cause
    ... was running Oracle 8.1.7.0.0 with a large database ... The system was updated to Oracle 8.1.7.4.0, ... This system was configured last year, and a 23Gb data file was created ... then in exactly the same way without this problem, no Tru64 upgrades ...
    (comp.unix.tru64)
  • Re: Issues with CHANGE_TRACKING AUTO after initial index population
    ... There's a problem with 64 bit SQL 2005 server. ... Director of Text Mining and Database Strategy ... started the FT initial index population when our site activity is low. ... High activity on the data file. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Network
    ... I was planning to load the database on to the server and have ... it is not *recommended* to have multiple users in the same ... The "best practice" is to split the application into a data file (tables ... not recommend that if the data is mission critical and I would certainly ...
    (microsoft.public.access.gettingstarted)
  • Re: Replication for Access
    ... > new unreplicated database. ... data file you started out with becomes the design master. ... replica with the same name in the location where the pre-replicated ... If you are still getting the error, exit Access, open Windows ...
    (microsoft.public.access.replication)
  • RE: No data in Backend
    ... Each client has their own computer and their data is ... As I stated in my orginal question this problem of no data in the data file ... and not being able to locate the data file, ONLY occurs on Window Vista ... My database is developed using MS Access 2003 and is split. ...
    (microsoft.public.access.modulesdaovba)