1,105,625 Community Members

How to alter table storage?

Member Avatar
rje7
Junior Poster in Training
93 posts since Mar 2008
Reputation Points: 2 [?]
Q&As Helped to Solve: 10 [?]
Skill Endorsements: 0 [?]
 
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?

Member Avatar
debasisdas
Posting Genius
6,542 posts since Feb 2007
Reputation Points: 580 [?]
Q&As Helped to Solve: 476 [?]
Skill Endorsements: 25 [?]
Featured
 
0
 

Please read more here.

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