RE: ORA-25153: Temporary Tablespace is Empty

From: Alessandro Lia [mailto:a.lia_at_tct-it.com] Sent: 05 February 2010 11:17
To: Robertson Lee - lerobe; Oracle-L_at_FreeLists.org Subject: Re: ORA-25153: Temporary Tablespace is Empty

I add a tempfile (256M) as you said and now it returns the following error:  

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP    

• Original Message ----- From: Robertson Lee - lerobe <mailto:Lee.Robertson_at_acxiom.com> To: Alessandro Lia <mailto:a.lia_at_tct-it.com> ; Oracle-L_at_FreeLists.org Sent: Friday, February 05, 2010 12:10 PM Subject: RE: ORA-25153: Temporary Tablespace is Empty

        Its as I said. Add a datafile to your temporary tablespace.

	From: Alessandro Lia [mailto:a.lia_at_tct-it.com] 
	Sent: 05 February 2010 10:56
	To: Robertson Lee - lerobe; Oracle-L_at_FreeLists.org
	Subject: Re: ORA-25153: Temporary Tablespace is Empty
	
	
	release 9.2.0.8.0
	created by the prod instance on 11- Nov - 09
	May you give me more details on your solution?

		----- Original Message ----- 
		From: Robertson Lee - lerobe <mailto:Lee.Robertson_at_acxiom.com>  
		To: a.lia_at_tct-it.com 
		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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Alessandro Lia
		Sent: 05 February 2010 10:37
		To: Oracle-L_at_FreeLists.org
		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?
		 

		Thanks

		Alessandro Lia
		Taranto Container Terminal S.p.A.
		Computer Department
		Tel: +39 099 4622221
		Fax: +39 099 4622300
		e-mail: a.lia_at_tct-it.com <mailto: a.lia_at_tct-it.com> 

		This e-mail is intended only for the person addressed. It may contain confidential 
		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
		collaborazione. 
		
		
		

		***************************************************************************
		The information contained in this communication is confidential, is
		intended only for the use of the recipient named above, and may be legally
		privileged.
		
		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.
		****************************************************************************

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