DSXchange

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.......

vinsashi wrote:table size was increased.

Think you need to increase the TEMP tablespace size

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.

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