ну средняя табличка выходит...
да вот уже когда на редактирование выходишь:
Options for extension of tablespace PSAPBWPUSR (1. file)
1 * Last added file name (lastfile) ....... [/oracle/BWP/sapdata4/bwpusr_11/bwpusr.data11]
2 * Last added file size in MB (lastsize) . [1890]
3 - New file to be added (file) ........... [/oracle/BWP/sapdata4/bwpusr_12/bwpusr.data12]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [1890]
6 - File autoextend mode (autoextend) ..... [yes]
7 - Maximum file size in MB (maxsize) ..... [10000]
8 - File increment size in MB (incrsize) .. [20]
9 - SQL command (command) ................. [alter tablespace PSAPBWPUSR add datafile '/oracle/BWP/sapdata4/bwpusr_12/bwpusr.data12' size 1890M autoextend on next 20M maxsize 10000M]
а вот если раскрыть в db02 - Files, то показывает YES autoextend...
File name File Id Tablespace name Size(MB) #Blocks Status Relative file number Autoextend
/oracle/BWP/sapdata4/bwpusr_1/bwpusr.data1 12 PSAPBWPUSR 10000,00 1280000 AVAILABLE 12 YES
/oracle/BWP/sapdata4/bwpusr_10/bwpusr.data10 24 PSAPBWPUSR 1890,00 241920 AVAILABLE 24 YES
/oracle/BWP/sapdata4/bwpusr_11/bwpusr.data11 25 PSAPBWPUSR 1890,00 241920 AVAILABLE 25 YES
/oracle/BWP/sapdata4/bwpusr_2/bwpusr.data2 16 PSAPBWPUSR 10000,00 1280000 AVAILABLE 16 YES
/oracle/BWP/sapdata4/bwpusr_3/bwpusr.data3 17 PSAPBWPUSR 10000,00 1280000 AVAILABLE 17 YES
/oracle/BWP/sapdata4/bwpusr_4/bwpusr.data4 18 PSAPBWPUSR 10000,00 1280000 AVAILABLE 18 YES
/oracle/BWP/sapdata4/bwpusr_5/bwpusr.data5 19 PSAPBWPUSR 10000,00 1280000 AVAILABLE 19 YES
/oracle/BWP/sapdata4/bwpusr_6/bwpusr.data6 20 PSAPBWPUSR 10000,00 1280000 AVAILABLE 20 YES
/oracle/BWP/sapdata4/bwpusr_7/bwpusr.data7 21 PSAPBWPUSR 1890,00 241920 AVAILABLE 21 YES
/oracle/BWP/sapdata4/bwpusr_8/bwpusr.data8 22 PSAPBWPUSR 1890,00 241920 AVAILABLE 22 YES
/oracle/BWP/sapdata4/bwpusr_9/bwpusr.data9 23 PSAPBWPUSR 1890,00 241920 AVAILABLE 23 YES
BLE 23 YES