RE: Initialization parameter transactions_per_rollback_segment, can you set this?
- From: "Arnold, Sandra" <ArnoldS@xxxxxxxx>
- To: "sol beach" <sol.beach@xxxxxxxxx>
- Date: Tue, 16 Aug 2005 11:49:16 -0400
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@xxxxxxxxx]
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@xxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
