954,561 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

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
 

Please read more here .

debasisdas
Posting Genius
6,872 posts since Feb 2007
Reputation Points: 666
Solved Threads: 434
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: