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 -> index creation fails because temp tablespace is too small

index creation fails because temp tablespace is too small

From: karel <karelje007_at_ftd.nl>
Date: 27 Apr 2005 15:03:49 GMT
Message-ID: <426fa9d5$0$24221$ba620dc5@nova.planet.nl> 





Hi, 



i have a problem. I'm enabling a unique constraint, that is 
creating a index on a table. The table contains 135000000 rows 
( 13 GB)


my temp tablespace is 3 gb big.



when i enable the constraint it keeps failing because the temp 
tablespace is to small.



is there a workaround for this issue and how big must temp be 
when it wil enable succesfully.



thx


michel
Received on Wed Apr 27 2005 - 10:03:49 CDT












Original text of this message













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