Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: To or not to hot backup the TEMP space
Disagree. If it's dictionary managed temporary tablespace (ie, the
'temporary' keyword was tacked on to the end of the regular 'create
tablespace' command), then the fact that it's dictionary managed is
irrelevant: there still cannot be anything of permanent interest contained
within it.
It is true that you won't get your database open without such datafiles, but a quick 'alter database datafile X offline drop' does the business. An 'alter database open' followed by a 'drop tablespace temp' and a 'create tablespace temp' completes the business.
Given that temporary tablespaces can be huge, it seems pointless madness to back it up, ever, unless you've got all the time in the world in which to do your backups, and all the disk space or tape space you could ever ask for.
Regards
HJR
-- ----------------------------------------------- Resources for Oracle : http://www.hjrdba.com =============================== "Ted McCabe" <the_om_at_gte.net> wrote in message news:tg6r8.3082$WQ4.235_at_nwrddc02.gnilink.net...Received on Thu Apr 04 2002 - 22:01:45 CST
> If it is dictionary managed, it should be. If it is locally managed
> tempfile it should not.
> HTH
> tED
> "Nabil Courdy" <moab88_at_emirates.net.ae> wrote in message
> news:ae1f8554.0204040100.41f4b8ec_at_posting.google.com...
> > Do the datafiles for the TEMP table space have to be backed up in a hot
> backup?
> > Currently, my script is not picking up these data files. (8.1.7 on
> Solaris)
> >
> > Nabil
> > =====
> >