RE: Initialization parameter transactions_per_rollback_segment, can you set this?

It needs to commit after each record so that it will be easy to recover at the next record to be loaded if something happens during the load. For instance, if you are loading 100,000 records you do not need to load all 1000,000 again if a problem occurs during the load. You can pick back up at the next record to be loaded. The process logs each unique identifier that it loads so that you know where it was in the process when it failed.

Sandra
-----Original Message-----
From: sol beach [mailto:sol.beach_at_gmail.com] Sent: Tuesday, August 16, 2005 10:59 AM
To: Arnold, Sandra
Cc: Oracle-L
Subject: Re: Initialization parameter transactions_per_rollback_segment, can you set this?

On 8/16/05, Arnold, Sandra <ArnoldS_at_osti.gov> wrote: [...snip...]
>
>
> I am getting snapshot too old errors for a transaction that is
committing
> after each record is inserted or updated.

Do NOT commit after each record.
COMMIT once at the end

--
http://www.freelists.org/webpage/oracle-l