Hi,
When I ran DB02 -> Space -> Tablespaces -> Overview, I see tablespace 'PSAPSR3701X' have Autoextend = 'NO'.
How I change Autoextend = 'YES' for that tablespace?
Note I already altered data files to AuExt. = 'YES' as below.
List of database data files
Pos. Tablespace Status Type File
Id. Size[KB] Device Back. AuExt. MaxSize[KB] IncrSize[KB]
1 - PSAPSR3701X ONLINE FILE /oracle/DEV/sapdata4/sr3701x_1/sr3701x.data1
35 22528000 16777219 NO YES 30720000 20480
2 - PSAPSR3701X ONLINE FILE /oracle/DEV/sapdata4/sr3701x_2/sr3701x.data2
36 20480000 16777219 NO YES 30720000 20480
3 - PSAPSR3701X ONLINE FILE /oracle/DEV/sapdata4/sr3701x_3/sr3701x.data3
37 20480000 16777219 NO YES 30720000 20480
4 - PSAPSR3701X ONLINE FILE /oracle/DEV/sapdata4/sr3701x_4/sr3701x.data4
38 6902784 16777219 NO YES 10240000 20480
Please advice.
Best regards,
Choosak B.