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 -> Possible causes of ORA-01630: max extents reached.

Possible causes of ORA-01630: max extents reached.

From: <tmcconechy_at_bcbc.bc.ca>
Date: Wed, 15 Apr 1998 14:51:09 -0600
Message-ID: <6h333d$kjo$1@nnrp1.dejanews.com> 





When running a report in our production system which used to work fine.
The client recieves the ORA-01630: max extents (249) reached in temp segment
in tablespace TEMP.



There are many extents and over 500 megs of space left for the system.



What could possibly be causing my problem.



Thanks for any advise!



-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/   Now offering spam-free web-based newsreading
Received on Wed Apr 15 1998 - 15:51:09 CDT












Original text of this message













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