Re: COMMIT in for loop

Is your code small enough for you to post so we can have a peek?

M

amyleone_at_my-deja.com wrote in message <7klhuv$bf4$1_at_nnrp1.deja.com>...
>In article <376AA2B5.B5A1CED5_at_lucent.com>,
> Kenneth C Stahl <kstahl_at_lucent.com> wrote:
>> It may be a rollback segment problem.
>
>You must be right because when I try it again I get:
>
>ERROR at line 1:
>ORA-01555: snapshot too old: rollback segment number 8 with name
>"RBSLRG07" too
>small
>
> What version of the RDBMS are you
>> working with?
>>
>7.3.3.6. They are planning to go to 7.3.4 real soon.
>
>> 1. Make sure that you have a rollback segment that has an OPTIMAL size
>> set
>
>How can I determine this?
>> 2. Make sure you use that rollback segment by SET TRANSACTION USE
>> ROLLBACK SEGMENT xx;
>>
>> Also, make sure that your commit encompasses an entire transaction -
>> that way if an error occurs you won't end up with a partial
>transaction.
>>
>> Ken
>
>Thanks for your help!
>>
>> amyleone_at_my-deja.com wrote:
>>
>> > I am getting an Oracle internal error when doing a COMMIT
>> > inside a FOR loop in my PL/SQL procedure. Are you not
>> > allowed to do that? It was working before, in fact it
>> > works for about 200000 rows before it crashes. Thanks
>> > for any help you can give.
>> >
>> > Amy
>> >
>> > Sent via Deja.com http://www.deja.com/
>> > Share what you know. Learn what you don't.
>>
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Mon Jun 21 1999 - 10:34:36 CDT