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?
Related Article: alter table
is a Oracle discussion thread by dan_t that has 2 replies and was last updated 2 years ago.
rje7
Junior Poster in Training
88 posts since Mar 2008
Reputation Points: 12
Solved Threads: 9
Skill Endorsements: 0
debasisdas
Posting Genius
6,968 posts since Feb 2007
Reputation Points: 722
Solved Threads: 457
Skill Endorsements: 20