Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Issue upgrading to 10g
> Any thoughts??
yes.
there is no tempfile for the temporary tablespace of interest.
add one.
(SQL> alter tablespace <tsname> add tempfile <path> size <bytes> ; )
If you lack temp files, a query against dba_temp_files will throw an
error.
Query v$tempfile instead to see what tempfiles are missing.
also - an alter database backup controlfile to trace will tell you what tempfiles oracle expects to "see" if you were creating a new controlfile.
hth
-bdbafh Received on Wed Feb 08 2006 - 14:01:43 CST