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

Hello Griffin

I am refering to Sql loader log file. When you load the data using SQL Loader it genarates a log file.

When you use SQL Loader

Direct path : No need to commit. It will not keep in the redo instead writes to the disk. (As it writes direct to the disk it is faster and no need for commit)

Conventional Path. It writes to redo and automatically commits after 64 records loaded (You can increase or decrease this 64 records)

In conventioanl path loading as your users mentioned in case if it crashes during loading you have to recover the database.

Assume that there are 3000 records to load. SQL Loader loaded 1500 recods and system crashes. You were not sure that all the 1500 records were loaded. It depends when checkpoit forced and writes from redo to disk.

If U want to use SQL or strored procedure Just put Commit at the end.

So try Direct path loading.

If you want to know more about Direct path loading and conventional path loading you can verify Oracle 7.3 manual for SQL Loader (I think you can browse this in Oracle site)

Regards

Eswar

In article <7ara7d$lrh$1_at_nnrp1.dejanews.com>,   chengcs_at_my-dejanews.com wrote:
> 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
>

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