How do you change the storage parameters of a already made table (sql developer)?
0
votes
2
answers
1053
views
**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!
Asked by XileVoid
(107 rep)
Sep 2, 2020, 06:53 AM
Last activity: Feb 26, 2025, 06:23 AM
Last activity: Feb 26, 2025, 06:23 AM