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?