Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 2 problems in using package........
Hi !
> > After the package is finish running, following message show:
> > ORA-01555:snapshot too old(rollback segment too small)
> > ORA-06512: at "USER.UPDATE_CCC", line 14
> >
> > 2) Could anyone tells me why such message show and how to
solve this
> > problem?
Your rollback segment is small, it isn't able to provide the original state of TTT during the loop because of other user's DML statements. Increase rollback segments.
Bye: Bert -- : ----.----, ------------------------------:---------------------------- --;----"-----, ,--------, ,--------, | Bertalan Gombos | | ;--------' | | software engineer ---|----------' `-------- | | bgombos_at_freemail.c3.hu `----' --------------------------------- `------------------------ '98Received on Mon Sep 07 1998 - 00:00:00 CDT