RE: temp tablespace blow up
- From: "Alvaro Jose Fernandez" <alvaro.fernandez@xxxxxxxxx>
- To: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>, <lyallbarbour@xxxxxxxxxxxxxxx>
- Date: Wed, 15 Aug 2007 13:02:31 +0200
You're right Mark.
thanks for the URL,
Alvaro
________________________________
De: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxxxxx]
Enviado el: martes, 14 de agosto de 2007 22:47
Para: Alvaro Jose Fernandez; lyallbarbour@xxxxxxxxxxxxxxx
CC: oracle-l@xxxxxxxxxxxxx
Asunto: RE: temp tablespace blow up
A tempfile is not just another datafile. For one thing, it's initially
sparse. For another, a tempfile tablespace does not need to be backed
up, and at recovery time, is simply (and quickly) recreated.
For a good summary of the different possible types of temporary
tablespaces, see this URL:
http://www.ixora.com.au/newsletter/2001_06.htm#temp
Yes, it's dated, but it's still accurate.
-Mark
Other related posts:
