RE: temp tablespace blow up

What is a TEMPORARY TABLESPACE?  

It is a tablespace that holds temporary objects used for sorts, joins, etc, when they don't fit into memory.

Temporary tables are also stored there.  

The TEMPORARY designation allows Oracle to do more efficient space allocation on objects that are temporary or needed for an ephemeral operation.

There should to be at least one default temporary tablespace or things don't work well.  

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/physical.htm# sthref512  

-T
   

--

http://www.freelists.org/webpage/oracle-l Received on Tue Aug 14 2007 - 10:07:36 CDT