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

From: <chengcs_at_my-dejanews.com>
Date: Mon, 22 Feb 1999 10:06:41 GMT
Message-ID: <7ara7d$lrh$1@nnrp1.dejanews.com>

Hello eswar

In article <7ar2m4$f7h$1_at_nnrp1.dejanews.com>, eswar_oracle_at_hotmail.com wrote:
> Hi Griffin
>
> Step 3. Verify the Log.
>

Sorry, but what do you mean by "the Log".

> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

I think the latter one (using temp tbl) may be slower but it is safer (in terms of crash-protection, of course). BTW, is there a way that I can commit after a number of "insert" operations? I am sorry I cannot find any related material around for the time being.

Thank you very much for your help.

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 - 04:06:41 CST