| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: temp file does not exist
Maria
Oracle doesn't consider temp files to contain critical information, so it doesn't recover them. I had just the symptom you are experiencing last week. What you need to do is ALTER TABLESPACE ADD TEMPFILE. If you still have your tempfile, you can specify REUSE. If not, then you'll have to add the storage parameters so Oracle can create it.
Dennis Williams
DBA, 60%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Thursday, May 01, 2003 12:17 AM
To: Multiple recipients of list ORACLE-L
I just did an alter database rename file on the new server (oracle9i -
just starting to user it)
and I encountered a 'datafile, logfile or tempfile does not exist' error
or something like that for my datafile for the temp tablespace. funny
thing is dictionary shows that there indeed is a TEMP tablespace with no
datafiles.
hmmm. how did that happen? i have this temp tablespace defined ok on the
original server.
I could add the datafile to temp but I can't understand why my
controlfile doesn't have a listing for my temp datafile.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Maria Aurora de la Vega
INET: mtdelavega_at_pse.org.ph
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu May 01 2003 - 08:46:37 CDT
 |
 |