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 -> why create index uses system tablespace?

why create index uses system tablespace?

From: <badstreetboy_at_my-dejanews.com>
Date: Fri, 13 Nov 1998 23:38:20 GMT
Message-ID: <72iftd$2j9$1@nnrp1.dejanews.com> 





When I tried to create an index on a large table, I found that it used a large
amount of size in the SYSTEM tablespace during the process.  Sometimes it even
give me an error message: ORA01652: unable to extend temp segment by num in
tablespace SYSTEM.



Why is that happen and how to prevent that??  THanks!!



BSB


-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    
Received on Fri Nov 13 1998 - 17:38:20 CST












Original text of this message













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