Re: Help with rollback problems

Graeme,
8.0.5 has a option nologging may able to solve your problem.

insert into table_a nologging
select ... from table_b

Ted Chyn
In article <3782013b.101404294_at_news.u-net.com>,   graeme_at_u-net.net 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
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 06 1999 - 12:42:28 CDT