Re: Problem with rollback segements

When you say no logging it does not mean that rollback will not be generated, what is means is redo logging will not be done or in other words redo will not be generated.

This just to clarify the meaning of logging to you.

Hope this helps a little bit!!

Cheers,
Manoj Jain
Certified Oracle DBA

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
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Jun 02 1998 - 03:03:56 CDT