Sample Header Ad - 728x90

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