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).
Received on Thu May 01 2003 - 00:16:38 CDT
