Solution : https://service.sap.com/sap/support/notes/3155 (SAP Service marketplace login required)
Summary :
The SAP Note addresses various Oracle errors related to tablespace extension issues (ORA-01650, ORA-01651, ORA-01652, etc.). These errors occur when Oracle cannot allocate the needed space for database operations. Solutions include changing NEXT_EXTENT values, analyzing SQL operations for temporary tablespace overflows, and checking parameter settings for optimal performance. For undo tablespace issues (ORA-30036), verify retention guarantees and disable if necessary. For LOB segment issues (ORA-01691, ORA-01692), review PCTVERSION settings. Consider enabling AUTOEXTEND for data files to prevent overflows and use BRSPACE for manual adjustments. Refer to additional SAP notes for specific Oracle versions.
Key words :
extend lob segment <lob> partition <part>, alter user <username> temporary tablespace <psaptemp>, extend index <ind> partition <part>, extend table <tab> partition <part>, alter database datafile '<path_and_name>' autoextend, alter tablespace psapundo retention noguarantee, extend lob segment <lob>, lob segment-specific termination, extend rollback segment <rbs>, extend save undo segment
Related Notes :
| 1045320 | ORA-30036 despite high number expired/unexpired undo extents |
| 761171 | CPCC Service Package 2.2.300 |
| 666061 | FAQ: Database objects, segments and extents |
| 659946 | FAQ: Temporary tablespaces |
| 584548 | Unusually high number of redo logs |
| 500340 | FAQ: LOBS |
| 489690 | CC INFO: Copying large production clients |
| 170989 | Poor performance under Oracle 8044, 805*, 8.0.6 |
| 96296 | CC-ERROR: Database problem in client copy |
| 78991 | Update hangs; locks gather |
| 67205 | CC-INFO: Copying large and productive clients |
| 63144 | GEN_SAPDEXT_CALLED |
| 35415 | CC-TOPIC: Memory space analysis / Test run |
| 3807 | Error messages regarding rollback and undo segments |