Re: Help with rollback problems

On Tue, 06 Jul 1999 10:13:02 -0400, Kenneth C Stahl <BluesSax_at_Unforgettable.com> wrote:

the actual select statement is:

insert into e3radacct select
user_name,startdate,stopdate,acct_session_time from stats.radacct where
user_name in (select hostname from busye3);

and the error given even with autocommit on is:

insert into e3radacct select
user_name,startdate,stopdate,acct_session_time from stats.radacct where

            *
ERROR at line 1:
ORA-01555: snapshot too old: rollback segment number 6 with name "RG" too small

I set autocommit to on with the line

set autocommit on

cheers

Graeme

>How are you copying the rows? With a insert...select? Programatically
>through Pro-C or PL/Sql? If you are doing it through insert...select, do
>you have AUTOCOMMIT on?
>
>Ken
>
>Graeme Hinchliffe wrote:
>
>> Hiya
>> I have recently started working with Oracle 8.0.5. The task I
>> am trying to achieve is to copy a large number of rows from one table
>> to another to speed up a query. The number of rows is around the
>> 200,000 figure from a table of about 1 million. The problem I am
>> getting is that when I run my query (which annoyingly worked first
>> time) I get this error:
>>
>> ORA-01555: snapshot too old: rollback segment number 9 with name "RG3"
>> too small
>>
>> I have tried to adjust the rollback setings with the Oracle Storage
>> manager, but whenever I set a new rollback segment to Online I then
>> cannot access it any longer and get the error..
>>
>> ERROR initializing rollback ORA-00942 table or view does not exist.
>> If I right click on a rollback segment it crashes the client!
>>
>> I have tried increasing the size of the RBS table to 100 Meg but still
>> get this error (it was initially set to about 10K!! (would I need to
>> add a new rollback segment for it to use this new space that I have
>> added?
>>
>> Also is there a way of turning off the rollback, so data is writen
>> directly to the db without going through the rollback ??
>>
>> Please help.. this is driving me nuts..
>>
>> Thanx in advance
>>
>> Graeme
Received on Tue Jul 06 1999 - 10:31:34 CDT