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

From: Steve Phelan <stevep_at_toneline.n-o-s-p-a-m.demon.co.uk>
Date: Mon, 22 Feb 1999 22:29:15 +0000
Message-ID: <36D1DA3B.376054DE@toneline.n-o-s-p-a-m.demon.co.uk>

You've already found it. The replies you got tell you most of what you need to know, but study the Oracle Utilities manual and the Server Concepts to put it in a 'safer' context for you.

Btw, we use SQL*Loader to push 20,000,000 records per week into to our main database, so I think you can rest assurred that it's OK for the volumes you quote. Still, always check your logs and maybe add some 'post-load quality checking code' to your load suite.

Steve Phelan

(Oracle 7 & 8 OCP)

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
Received on Mon Feb 22 1999 - 16:29:15 CST