You have set the data file autoextend to YES but when you checked from transaction code DB02, the status still showing NO.
Solution
1. Refresh / update the data for transaction code DB02. To do this, execute transaction code DB02 and press F8 (or click on Refresh icon). Wait till the process completed and you will see the latest output.
2. If the step 1 not working, check the value maintained in size & maxsize on previous tablespace extend. You can find the value by referring to this article, Tablespace Extend with SAP BRTOOLS – the value is at step 7. If the value of size & maxsize is same, the autoextend status will show NO. To cater this, in future, when you do the tablespace extend – you need to fill the value of maxsize greater than size. Then, the status will be YES.
------------------------------------------------------------------------------- Options for extension of tablespace PSAPSR3 (1. file) 1 * Last added file name (lastfile) ....... [/oracle/<SID>/sapdata4/sr3_20/sr3.data20] 2 * Last added file size in MB (lastsize) . [2160] 3 - New file to be added (file) ........... [/oracle/<SID>/sapdata4/sr3_21/sr3.data21] 4 ~ Raw disk / link target (rawlink) ...... [] 5 - Size of the new file in MB (size) ..... [2160] <-- THIS VALUE 6 - File autoextend mode (autoextend) ..... [yes] 7 - Maximum file size in MB (maxsize) ..... [10000] <-- THIS VALUE 8 - File increment size in MB (incrsize) .. [20] 9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/<SID>/sapdata4/sr3_21/sr3.data21' size 2160M autoextend on next 20M maxsize 10000M] Standard keys: c - cont, b - back, s - stop, r - refr, h - help -------------------------------------------------------------------------------
Awesome Blog. Really helped me.
Keep up the good work