Problem with rollback segements

From: <arundeja_at_my-dejanews.com>
Date: Tue, 02 Jun 1998 00:29:51 GMT
Message-ID: <6kvh1u$joo$1@nnrp1.dejanews.com>

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 Received on Mon Jun 01 1998 - 19:29:51 CDT