Re: Allocating memory for Bulk Inserts

From: oidba <oidba_at_yahoo.com>
Date: 7 Jan 2004 21:38:39 -0800
Message-ID: <e61db2dc.0401072138.7294c1d0_at_posting.google.com>


> > SQL*LOADER is not an option
>
> I am sorry: Why not ?

[Quoted] [Quoted] We're talking zero room for error in this situation. This is a [Quoted] telecomm call charging application. Unless Oracle provides a C/C++ [Quoted] SQL*LOADER API, I would not bet too much on SQL*LOADER to provide the appropriate error handling and transaction control needed. How do you suppose I rollback a transaction once SQL*LOADER has loaded the table. [Quoted] [Quoted] I would not want to depend on the return value from a "system()" or "popen()" to handle the errors. Should one file be incorrectly processed, a tedious and time consuming task of batch cleaning would have to take place to manually rollback. Received on Thu Jan 08 2004 - 06:38:39 CET

Original text of this message