RE: ORA-25153: Temporary Tablespace is Empty
- From: "Robertson Lee - lerobe" <Lee.Robertson@xxxxxxxxxx>
- To: <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 5 Feb 2010 11:24:55 -0000
RTFM time my friend
________________________________
From: Alessandro Lia [mailto:a.lia@xxxxxxxxxx]
Sent: 05 February 2010 11:17
To: Robertson Lee - lerobe; Oracle-L@xxxxxxxxxxxxx
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@xxxxxxxxxx>
To: Alessandro Lia <mailto:a.lia@xxxxxxxxxx> ; Oracle-L@xxxxxxxxxxxxx
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@xxxxxxxxxx]
Sent: 05 February 2010 10:56
To: Robertson Lee - lerobe; Oracle-L@xxxxxxxxxxxxx
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@xxxxxxxxxx>
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?
Thanks
Alessandro Lia
Taranto Container Terminal S.p.A.
Computer Department
Tel: +39 099 4622221
Fax: +39 099 4622300
e-mail: a.lia@xxxxxxxxxx <mailto: a.lia@xxxxxxxxxx>
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.
****************************************************************************
Other related posts:
