Member Avatar for rje7

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
  • 144 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

Please read more here.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.