RE: temp tablespace blow up

From: Alvaro Jose Fernandez <alvaro.fernandez_at_sivsa.com>
Date: Wed, 15 Aug 2007 13:02:31 +0200
Message-ID: <607D6181D9919041BE792D70EF2AEC481CFF91@LIMENS.sivsa.int>

You're right Mark.

thanks for the URL,

Alvaro

De: Bobak, Mark [mailto:Mark.Bobak_at_il.proquest.com] Enviado el: martes, 14 de agosto de 2007 22:47 Para: Alvaro Jose Fernandez; lyallbarbour_at_sanfranmail.com CC: oracle-l_at_freelists.org
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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 15 2007 - 06:02:31 CDT