"Fraser McCallum" <fmcc_at_removetoemail_odbaguru.com> wrote in message
news:Jgwj8.10101$uR5.18716_at_newsfeeds.bigpond.com...
>
> I'm assuming you have used the 8i temporary files, i.e. this file shows up
> when you query DBA_TEMP_FILES. You can't rename locally managed temporary
> files, just as you can't recover them. However this is not a problem as
> being a temporary file means that no data is stored in them. So for your
> move just drop and recreate the tablespace.
The following is from the 8.1.6 ALTER DATABASE docs. Given you statement, I
find the mention of tempfiles confusing
---
RENAME FILE
renames datafiles, tempfiles, or redo log file members. This clause renames
only files in the control file. It does not actually rename them on your
operating system. You must specify each filename using the conventions for
filenames on your operating system before specifying this clause.
---
Is it documented anywhere that tempfiles cannot be renamed?
BTW, my code for handling tempfiles does an ALTER TABLESPACE ADD TEMPFILE
... and an ALTER DATABASE TEMPFILE ... DROP. Total lack of symmetry, but it
works.
Thanks for assuring my solution. I feel a bit less stupid, now.
--
Later,
BEDick
Received on Wed Mar 13 2002 - 12:27:04 CST
