Skip to Content
0
Former Member
Apr 09, 2010 at 03:48 AM

DB02 Tablespace Autoextend NO

336 Views

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.