Solution : https://service.sap.com/sap/support/notes/16277 (SAP Service marketplace login required)
Summary :
This SAP Note identifies an error where transactions involving large data volumes like imports or client copies fail with ORA1562 and ORA1628 errors relating to rollback segments. The root cause is the insufficiently set "maxextents" storage parameter for rollback segments. As a resolution, the note advises altering the "maxextents" parameter for all rollback segments (e.g., prs_1 to prs_10) to a higher value, suggesting 300 as adequate. This adjustment is performed via SQLDBA with a specific sequence of commands to connect internally and modify the parameter settings. This fix aims to prevent transaction failures by allowing adequate space for rollback operations.
Key words :
sqldba lmode=ysqldba> connect internalsqldba> alter rollback segment <, additional key words psaproll, solution change storage parameter, extend rollback segment, processes mass data, ora1628 max # extents, rollback segment %, sqldba> exit, storage parameter, rollback segments
Related Notes :
| 533455 | Terminations due to higher number of extents |
| 63639 | Error in activating an operating concern |
| 60233 | Oracle rollback segments, more information. |
| 3807 | Error messages regarding rollback and undo segments |