Solution : https://service.sap.com/sap/support/notes/60233 (SAP Service marketplace login required)
Key words :
terms ora-01555 ora-01628 ora-01650 fet prs_1 prs_2 prs_3 prs_4 prs_5 prs_6prs_7 prs_8 prs_9 prs_10 rbs rollback segment max extentssnapshot psaproll optimal reason, create tablespace psaproll datafile'/oracle/<yoursid>/sapdata/roll_1/roll, tools -> admin -> monitoring -> performance -> database -> activitythen -> press, sap menu -> adminstration -> monitoring -> performance -> database -> tables/indexes ->, sqldba> create rollback segment prs_01 tablespace psaproll storage, rollback segment createdalter rollback segment roll_temp offline, create rollback segment prs_2 tablespace psaproll, svrmgr> alter rollback segment rbs_1 shrink, sqldba> alter rollback segment prs_01 offline, sqldba> alter rollback segment prs_01 online
Related Notes :
| 1074030 | R3trans: "Duplicate key" composite SAP note (as of Rel 6.10) |
| 789390 | Material forecast: Error ORA-01555 for background forecast |
| 766827 | Composite SAP note: Performance SCM 4.0 |
| 489690 | CC INFO: Copying large production clients |
| 426021 | Archiving object BC_DBLOGS: Termination with Oracle DB |
| 383823 | MP38: Restriction according to materials |
| 360087 | Update task termination: Rollback segment too small |
| 338222 | Balance carryfwd: DBIF_RSQL_ERROR: Snapshot too old |
| 181275 | Reporting: error ORA 1555 and COMMIT WORK |
| 165247 | Notes on creating rollback segments |
| 125116 | REGUP, REGUH and BKPF in 4.0B upgrade with IS F3.04 |
| 123793 | SIS variant configuration:Termination S126 -> S127 |
| 118919 | Problems RMCVISCP (SQL error 1555) |
| 102034 | R3trans: Control of the COMMIT intervals |
| 96296 | CC-ERROR: Database problem in client copy |
| 88656 | R3trans: Duplicate key composite SAP note (Release 4.0-4.6) |
| 82634 | PSAPROLL-Which rollback segments created, and how? |
| 68896 | R3trans: Performance problems and cluster |
| 67205 | CC-INFO: Copying large and productive clients |
| 63639 | Error in activating an operating concern |
| 49111 | FI-SL: conversion of the line items is too slow |
| 35415 | CC-TOPIC: Memory space analysis / Test run |
| 16277 | ORA1562 / ORA1628 |
| 13655 | SAPDBA: Long runtimes: Exp./imp./reorganization |
| 3807 | Error messages regarding rollback and undo segments |