We're a community of 1077K IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,076,267 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

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?

2
Contributors
1
Reply
9 Minutes
Discussion Span
1 Year Ago
Last Updated
2
Views
rje7
Junior Poster in Training
88 posts since Mar 2008
Reputation Points: 12
Solved Threads: 9
Skill Endorsements: 0

Please read more here.

debasisdas
Posting Genius
6,968 posts since Feb 2007
Reputation Points: 722
Solved Threads: 457
Skill Endorsements: 20

This article has been dead for over three months: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
View similar articles that have also been tagged:
 
© 2013 DaniWeb® LLC
Page rendered in 0.6182 seconds using 2.66MB