Re: Problem with rollback segements

From: <saropani_at_my-dejanews.com>
Date: Thu, 04 Jun 1998 09:52:09 GMT
Message-ID: <6l5qo8$euq$1@nnrp1.dejanews.com>

In article <6kvh1u$joo$1_at_nnrp1.dejanews.com>, arundeja_at_my-dejanews.com wrote:
>
> I keep getting this error when I run a
> 'CREATE TABLE PARALLEL NOLOGGING AS SELECT .. GROUP BY ..' statement
>
> ORA-12801: error signaled in parallel query server P002
> ORA-01555: snapshot too old: rollback segment number 5 with name "R04" too
> small
>
> Why is it using a rollback segment if I have no rollback information being
> generated. Is there any way to avoid generating rollback information in
this
> case
>
> The stranger thing is that I first set rollback segment to 'R06'. But I get
> this error from segment 'R04' from within my procedure!!
>
> Any suggestions always welcome.
>
> Arun
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

u can use create table with unrecoverable option which won't use rollback segments,i guess this will solve ur problem.

bye
Saravanan

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Jun 04 1998 - 04:52:09 CDT