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 -> Re: Help ! problems with temp file

Re: Help ! problems with temp file

From: Erik Oosterling <Oosterling_at_compuserve.com>
Date: 1997/01/29
Message-ID: <32f04de2.17017204@news.xs4all.nl>#1/1

On Mon, 27 Jan 1997 17:02:18 +0100, Matthieu Exbrayat <exbrayat_at_lisiflory.insa-lyon.fr> wrote:

-->Unfortunately, I receive the following answer :
-->
-->"ORA-01658: unable to create INITIAL extent for segment in
tablespace
-->TEMP"
-->
-->I must tell you that our DBA is on holidays...
-->~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-->~ Matthieu EXBRAYAT |

~
-->~ LISI - INSA Lyon | e-mail : exbrayat_at_lisiflory.insa-lyon.fr
-->~ 69621 Villeurbanne Cedex |
-->~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2 options:

Decrease the size of the initial extent for TEMP. If the error keep returning, enlarge the TEMP tablespace.

Good luck !!

Greatings,

Erik Oosterling

101756,3156 <-> Compuserve
101756.3156_at_compuserve.com <-> Internet
ErikO_at_cmg.nl <-> Internet Received on Wed Jan 29 1997 - 00:00:00 CST

Original text of this message

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