Summarize the problem
I have been given 6 tables that have all been created already and I was told to change the storage parameters of those tables. the issue I run into is that I can only change pctfree, pctused, initrans and max trans and not the others (initial, next, pctincrease and maxextents)
Provide details and any research
I have done a lot of research, yet some of them do not work with sql developer at all. Whilst the others do work but as stated only for the 4 storage parameters.
When appropriate, describe what you’ve tried
alter table CUSTOMERS
pctused 20 pctfree 80;
This works perfectly for those two, but I am unable to add the others. From what I found online, this was in fact the only thing that worked for me.
I appreciate all input!
Best Answer
The extent parameters can not be changed of an existing table, they are specified when a table is created. You can change them by reorganizing the table.
Notice how the
MAX_EXTENTS
andPCT_INCREASE
parameter did not change. They are relevant only for dictionary managed tablespaces, but that was forgotten ages ago, we use locally managed tablespaces.