How to alter table storage?
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?
rje7
Junior Poster in Training
83 posts since Mar 2008
Reputation Points: 12
Solved Threads: 9
debasisdas
Posting Genius
6,872 posts since Feb 2007
Reputation Points: 666
Solved Threads: 434