Forum Stats

  • 3,873,270 Users
  • 2,266,529 Discussions
  • 7,911,490 Comments

Discussions

Bulk Copy without SQL *Loader

3004
3004 Member Posts: 204,171 Green Ribbon
--
Sybase and SQL Server ship with a bulk copy utility called 'bcp'
that lets you spew (for lack of a better term) data into a table
at obscene speeds compared to what you can do with INSERT
statements. I can use dblib, SQL-DMO, or SQLOLE to access this
functionality from Visual C++ or Visual Basic code without using
the 'bcp' utility.

SQL *Loader appears to perform bulk copies into Oracle.

If SQL *Loader can do it, why can't I? How would I go about
writing code to load an Oracle table with data from an operating
system file WITHOUT spawning SQL *Loader... Is there an
function in some DLL somewhere that'll let me do this? Maybe
I'm taking the wrong approach?

I'm using Oracle 8 and Visual Basic/Visual C++ on Windows NT
4.0, but if you've got an example in Java, Unix C, Pascal,
COBOL, FORTH, or anything, or some information that might get
me headed in the right direction, I'd be thrilled to see it.

Any and all help would be greatly appreciated.

Thanks,
Brandon Roberson
[email protected]
null

Comments

  • 3004
    3004 Member Posts: 204,171 Green Ribbon
    --
    Brandon Roberson (guest) wrote:
    : Sybase and SQL Server ship with a bulk copy utility called
    'bcp'
    : that lets you spew (for lack of a better term) data into a
    table
    : at obscene speeds compared to what you can do with INSERT
    : statements. I can use dblib, SQL-DMO, or SQLOLE to access this
    : functionality from Visual C++ or Visual Basic code without
    using
    : the 'bcp' utility.
    : SQL *Loader appears to perform bulk copies into Oracle.
    : If SQL *Loader can do it, why can't I? How would I go about
    : writing code to load an Oracle table with data from an
    operating
    : system file WITHOUT spawning SQL *Loader... Is there an
    : function in some DLL somewhere that'll let me do this? Maybe
    : I'm taking the wrong approach?
    : I'm using Oracle 8 and Visual Basic/Visual C++ on Windows NT
    : 4.0, but if you've got an example in Java, Unix C, Pascal,
    : COBOL, FORTH, or anything, or some information that might get
    : me headed in the right direction, I'd be thrilled to see it.
    : Any and all help would be greatly appreciated.
    : Thanks,
    : Brandon Roberson
    : [email protected]
    null
  • 3004
    3004 Member Posts: 204,171 Green Ribbon
    --
    Hello
    For me, if i home a bulk of data to load into oracle database
    (most in
    text). I will load data into excel and use function CONCATINATE
    to
    build insert statement for each record and save it into text file.
    After that, i'll using sql*plus to run script from text file
    (SQL>@file)
    thus data will flow to you table.
    Ohm
    null
This discussion has been closed.