1.11M Members

How to alter table storage?

 
0
 

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?

 
0
 

Please read more here.

You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: