Originally posted by rkiss
Because this procedure will insert over 1 mil. records and my temp tablespace is very limited. I let the procedure to run and after 5 hours I got the following error(Error): ORA-30036: unable to extend segment by 1024 in undo tablespace 'UNDOTBS1'.
frequent commits increase the chance of ora-1555 so you can commit frequently if you like but risk running into snapshot too old

why dont oyu just increase the size of the undo tbs?

steve