Re: Help with rollback problems

It's a little bit more work, but you can use the COPY command to insert into a table (you can usually just type copy in a sqlplus window to see what the syntax is). With COPY, you can SET ARRAYSIZE to to the number of records you want to work with in a batch and then SET COPYCOMMIT to the number of batches you want to commit after (if you have ARRAYSIZE of 25 and you COPYCOMMIT after 2 batches, you would commit every 50 records). Hope this helps.

Jeff S

Graeme Hinchliffe <graeme_at_u-net.net> wrote in message news:37852110.109554692_at_news.u-net.com...
> 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 - 18:55:58 CDT