Re: Insert rows from text into Oracle table by "batch"

Hi Griffin

This idea may not be nice may be you can try this.

you can use direct path load which will by pass writing it to Bind array

Other wise

Step 1. Create a Temp table similar to the Actual table

Step 2. Load the data into temp table.

Step 3. Verify the Log.

(If it crashes you can delete the data from temp table and reload it, I don't think it will take long time)

Step4. If evry thing is Ok then you can transfer the data two ways from temp table to actual table 1. Stored procedure, 2. In SQL plus issue Insert into Actualtable (Select * from temp table).

Regards

Eswar

In article <7aqmv4$61j$1_at_nnrp1.dejanews.com>,   chengcs_at_my-dejanews.com wrote:
> Hello,
>
> I am working on a project which requires importing data records daily from
> text files into Oracle (8.0.5) tables. The no of row is small to medium
> (estimated 3,000 to 6,000 records per day).
>
> I have experimented with SQL Loader with a few testing records and the result
> is fine. However, the users have concerns over the ability to recover from
> possible crashes during the import. Can anyone suggest a good solution?
>
> Thanks in advance.
>
> Griffin.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Feb 22 1999 - 01:57:58 CST