Re: Oracle7.3 - Need to backup temporary tablespace?

If you really want to skip backing up your tempwork tablespace, and you ever have to restore/recover, you would have to:

1. at the point before the recover command, alter datafile *name of your tempwork datafile(s)* offline
2. do your recovery
3. open the database, drop the tempwork tablespace, delete the datafile(s)
4. recreate the tempwork tablespace

This all supposes that you have no permanent objects like tables or indexes or such in this tablespace, and further that it is faster to do this than it is to back up the 'empty' space. Usually during recovery, everyone is breathing down your neck to get things running again. I would recommend backing it up myself. You don't need 'tricky-ness' going on during a recovery.

Wayne Linton
Shell Canada Ltd.

Roy Coleman wrote:
>
> I would back up the tablespace since the control file will be looking for
> it when you try to bring back up the database from a full restore.
>
> Kay Harris <Kay.Harris_at_dssc.slg.eds.com> wrote in article
> <01bc80bb$49e02fc0$73f95e94_at_dssp9115.dssc.slg.eds.com>...
> > Is there any reason to back up a "temporary" tablespace (as introduced in
> > version 7.3)?
> >
> >
> >
> >
Received on Wed Jul 02 1997 - 00:00:00 CDT