Re: ORA-25153: Temporary Tablespace is Empty

  • From: "Alessandro Lia" <a.lia@xxxxxxxxxx>
  • To: "Robertson Lee - lerobe" <Lee.Robertson@xxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
  • Date: Fri, 5 Feb 2010 11:55:35 +0100

created by the prod instance on 11- Nov - 09
May you give me more details on your solution?
  ----- Original Message ----- 
  From: Robertson Lee - lerobe 
  To: a.lia@xxxxxxxxxx 
  Sent: Friday, February 05, 2010 11:41 AM
  Subject: RE: ORA-25153: Temporary Tablespace is Empty

  What version of Oracle are you on ? Have you recently just created this 
database from a backup of another ?

  At pre 10.2 versions of Oracle, the temporary datafiles are not restored as 
part of a backup restore. You have to alter the tablespace and add them 
manually afterwards

  Hope this helps

  From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Alessandro Lia
  Sent: 05 February 2010 10:37
  To: Oracle-L@xxxxxxxxxxxxx
  Subject: ORA-25153: Temporary Tablespace is Empty

  Dear all,
  I need help about tha am error ORA-25153: Temporary Tablespace is Empty.

  I create a new view (using create like by OEM). My programmere run sql for 
such view and this error returned. 

  I checked the tbs and tha TEMP tbs had no datafile associated. I'm sure 
before it was.

  To solve I just want add one datafile, but why it can happen?


  Alessandro Lia
  Taranto Container Terminal S.p.A.
  Computer Department
  Tel: +39 099 4622221
  Fax: +39 099 4622300
  e-mail: a.lia@xxxxxxxxxx 

  This e-mail is intended only for the person addressed. It may contain 
  information and/or privileged material. If you receive this in
  error, please notify the sender immediately and delete the information from
  your computer. Please do not copy or use it for any purpose nor disclose
  its contents to any other person. Thank you for your assistance.

  La presente comunicazione potrebbe essere confidenziale nonché tutelata dal
  segreto professionale ed è comunque ad uso esclusivo del destinatario sopra
  indicato. Nel caso non fosse destinato a Voi, Vi preghiamo di volerci
  avvertire immediatamente e di distruggere quanto ricevuto. Grazie per la

The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally

If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank You.

Other related posts: