Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Primary key Index Problem

Primary key Index Problem

From: Dave <none_at_nowhere.nothere.oops>
Date: Mon, 29 Nov 1999 13:28:41 -0000
Message-ID: <81tv5s$qnb$1@lure.pipex.net> 





I am running this SQL statment



ALTER TABLE DAVE.ERMAIN



 ADD CONSTRAINT ERRECNUM PRIMARY KEY


   RECNUM)



 USING INDEX



 TABLESPACE ERINDEX PCTFREE 5



 STORAGE(INITIAL 10240 NEXT 10240 PCTINCREASE 0 )



Every time I have tried I run out of Rollback Extents
in the System rollback or one of the production rollbacks.
Max is 121, I can't alter this as Oracle complains.
Why does an index creation need rollback?




Any help


Dave



Received on Mon Nov 29 1999 - 07:28:41 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US