Re: "ORA-01555 snapshot too old and ORA-01658 unable to create

Richard C Haven wrote:
>
> We are getting these errors:
>
> 01555: snapshot is too old; rollback segment number 4 with name "R03"
> too small
>
> 01658: unable to create INITIAL extant for segment

  01555 will occur when your transaction is too long or involve too many undo information that will write to rollback segment. Additionally, your rollback segment is too small. As a result, when the rollback segment filled up with the active rollback information, it cannot allocate any additional space (so it leads to unable to create INITAL extent for segment) for store the remaining rollback information.

  You can solve this problem by either increase the size of your rollback segment or you can use a large rollback segment: SET TRANSACTION USE ROLLBACK SEGMENT rollback_segment_name_with_large_size at the beginning of the transaction.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841