How to change NEXT_EXTENT from os level.

[Former Member]

Hello All,

Please tell me how can i change the next_extent parameter from OS level.

I tried in Se14 but for this particular table, I cannot change it from SAP.

Thanks,

Anu

[Former Member · Accepted solution]

Hello,

I am not getting normal view for a particular table.

There is no option to change storage paraeter for this.

Please advise

Thanks,

Anu.

[former_member204746 · Accepted solution]

from OS level:

sqlplus / as sysdba

alter table sapr3.tst03 storage (next 30k);

good luck.

[Former Member]

Hello,

Tablespace is dictionary managed and oracle 10g.

thanks

Anu

[former_member204746]

you should be able to do it through SE14. that's the wya I use to play with this in the past. When you try, you get an error message? Have you clicked on the glasses/pencil button from Technical settings?

[former_member204746]

what is your Oracle version? Are you using LMTS tablespaces with ASSM? If so, you cannot change this in SE14 nor in OS tools.