Insert rows from text into Oracle table by "batch"

From: <chengcs_at_my-dejanews.com>
Date: Mon, 22 Feb 1999 04:37:57 GMT
Message-ID: <7aqmv4$61j$1@nnrp1.dejanews.com>

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 Received on Sun Feb 21 1999 - 22:37:57 CST