Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Error with a job

Former Member
0 Likes
559

Hi people!

I have a job that cancel with this error: (DBIF_RSQL_SQL_ERROR

the ORACLE instance needed additional storage space in a rollback segment.)

I'm a basis, how can I resolve this problem?

Thanks for the help!

1 ACCEPTED SOLUTION
Read only

Sandeep_Panghal
Product and Topic Expert
Product and Topic Expert
0 Likes
530

Hi,

Check transactions DB6SPACE and DB02 for table space details.

Hi people!

I have a job that cancel with this error: (DBIF_RSQL_SQL_ERROR

the ORACLE instance needed additional storage space in a rollback segment.)

I'm a basis, how can I resolve this problem?

Thanks for the help!

3 REPLIES 3
Read only

Former Member
0 Likes
530

Hi Carlos,

Generally these type of error occurs when there are many jobs running parallelly. So just ask them to restart it once and check if this is working or You need to clear the space for table access or increase the space.

Regards,

Vinod.

Read only

Former Member
0 Likes
530

Hi Vinod!

I process the job again and I see the same error, how can I clear the space for table access or increase the space?

Thanks!

Read only

Sandeep_Panghal
Product and Topic Expert
Product and Topic Expert
0 Likes
531

Hi,

Check transactions DB6SPACE and DB02 for table space details.