2007 Jan 03 2:08 PM
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!
2007 Jan 03 2:53 PM
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!
2007 Jan 03 2:14 PM
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.
2007 Jan 03 2:49 PM
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!
2007 Jan 03 2:53 PM
Hi,
Check transactions DB6SPACE and DB02 for table space details.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |