Re: Backup question - temp tablespaces

If you are running 8.1, then

create temporary tablespace TEMP
tempfile 'asdfasdfa' size XXXM reuse
uniform size XXM;

On recovery:

alter tablespace temp
add tempfile 'asdfasdfa' size XXXM reuse;

Otherwise your strategy of dropping and
recreating is the necessary one.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Syltrem wrote in message <64Wh6.3517$Iu3.61069_at_weber.videotron.net>...


>Hello!

>

>I am testing a db restore from cold backup but... I have not backed up the

>TEMP tablespace. Instead I have a script that says:

>ALTER DATABASE CREATE DATAFILE 'xyz' AS 'XYZ';

>

>Since the temp datafile is a TEMPORARY tablespace content, there is nothing

>in there that needs backing up and I figured I could re-create the file

>before ALTER DATABASE OPEN.

>

>It did not work as expected. I received the message that the file needed

>recovery. Why? I was finally able to do an ALTER DATABASE DATAFILE 'xx'

>OFFLINE DROP and ALTER DATABASE OPEN, after which I dropped the temp

>tablespace and recreated it.

>

>So I guess my method is not so good, and the question is:

>How would you go about not backing up the temporary tablespaces

(datafiles)?