job failed to extend rollback segment

[vinsashi]

Hi,
My job is using Target as Oracle enterprise stage.
Job is failing due to below issue.

Issue: ORA_DEPT_GRP_STORE_LNK,2: Unable to insert a record into the table due to ORA-01562: failed to extend rollback segment number 23

table size was increased.

Still job is failing due to same issue.


Thanks
vin.......

[HariK]

table size was increased.

Think you need to increase the TEMP tablespace size

[chulett]

That's a "problem" your DBA needs to solve by adding more rollback space. That or perhaps you need to commit more often in your job.

[vivekgadwal]

As Craig is suggesting, look into commiting more frequently. For now, check the log file space and see if it getting full.