RE: temp tablespace blow up

From: Alvaro Jose Fernandez <alvaro.fernandez_at_sivsa.com>
Date: Tue, 14 Aug 2007 20:55:44 +0200
Message-ID: <607D6181D9919041BE792D70EF2AEC481CFF8F@LIMENS.sivsa.int>

Just a dbfile like the others.

Just curious, which Oracle release you run? 8i?

Alvaro

De: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] En nombre de Lyall Barbour
Enviado el: martes, 14 de agosto de 2007 20:18 Para: oracle-l_at_freelists.org
Asunto: Re: temp tablespace blow up

just ran an update that had some stupid huge joins and couldn't allocate anymore extents because the 4gb of datafiles were too small. So my update errored. then, no problem still, just that my temp tablespace had an enormous amount of extents. So, i dropped it when users were off and recreated it as TEMPORARY. I've been reading about temporary tablespaces:

CREATE TEMPORARY TABLESPACE blah TEMPFILE '/d01/oradata/PROD/blah.dbf' size 1000M;

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 14 2007 - 13:55:44 CDT