SqlBulkCopy and Oracle?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bradley Plett (plettb_at_hotmail.com)
Date: 12/23/04 

Date: Wed, 22 Dec 2004 17:14:48 -0700

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

  • RE: Generic DBI question about backups
    ... Looks like I may have to go with a CSV type solution. ... Generic DBI question about backups ... Oracle db and the other to a csv db. ...
    (perl.dbi.users)
  • Re: Converting oracle tables data into csv on client computer
    ... >(Oracle 9i on solaris). ... But, if that fails, try asktom - I saw an article about producing csv ... 1) How can we manage this using sql? ... The convertion should be done on client computer and ...
    (comp.databases.oracle.server)
  • Re: Importing lg csv file into Access tbl
    ... It just when I try to export the data out of the tool into .csv ... I don't know much about Oracle specifically, but what I ususally do when I ... get the query working correctly there, then copy the SQL and paste it into ...
    (microsoft.public.access.externaldata)
  • Re: Binary compatible across Sparc platforms
    ... The system is running Solaris 8, and the storage unit mount ... UltraSparc IV. ... Buy a new storage unit, configure and mount it just like the the ... Finally, with Oracle down, just do a raw file of everything in the / ...
    (comp.sys.sun.hardware)
  • Re: Importing lg csv file into Access tbl
    ... I really don't want to link to the tables in the Oracle dB, ... My output data looks ... but when I try to save my results as .CSV so I can imported into Access ... some of the data get split into multiple columns which cause the data to ...
    (microsoft.public.access.externaldata)