rje7 Junior Poster in Training 94 posts since Mar 2008 Reputation Points: 2 [?] Q&As Helped to Solve: 10 [?] Skill Endorsements: 0 [?] •Community Member 0 3 Years Ago how can i alter the INITIAL and NEXT value of a table. I tried something and ended up with the following code. ALTER TABLE TABLENAME ADD ( PRIMARY KEY (ORDER_ID) USING INDEX TABLESPACE TALLYDATA PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 )); Will i be alter only the table space storage values without modifying any other attributes of the table?