SAP Note 3502 - ORACLE Version 6 : ORA1556, Version 7 : ORA1631

Composant : Oracle -

Solution : https://service.sap.com/sap/support/notes/3502 (Connexion à SAP Service Marketplace requise)

Résumé :
SAP Note identifies an Oracle error related to 'extent overflow' in versions 6 and 7, where a table exceeds its allowed maximum number of extents. This results in error 1556 and error 1631 respectively. To mitigate the issue, there are two solutions proposed. Firstly, adjusting the maximum number of extents where necessary, utilizing SAPDBA for a menu-guided interface which is beneficial during system run-time, or directly reorganizing the table which requires halting the SAP system. Alternatively, using UNIX/Oracle tools, adjustments can be made to storage parameters like 'next_extent' and 'max_extents', immediately allowing system operation continuation, followed by recommended table reorganization during non-peak times.

Mots Clés :
sqlplus sapr3/sapsql> select next_extent, sql> alter table apqd storage, sapdba meansthe sapdba method, unix level withoracle means, - alter/show table, - alter/show parametersif, symptom key word, additional key words, unix/oracle meansthese, current storage parameters

Notes associées :

122678
45861
31524Maxextent = 100 for new 3.0 installation
11777ORA-1632 max # extents <n> reached in index <ind.>