RE: temp tablespace blow up
- From: "Ted Coyle" <oracle-l@xxxxxxxxxxxx>
- To: <lyallbarbour@xxxxxxxxxxxxxxx>
- Date: Tue, 14 Aug 2007 11:07:36 -0400
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
Other related posts:
