TEMP TABLESPACE [message #445462] |
Tue, 02 March 2010 00:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
orafacjublu
Messages: 95 Registered: May 2006 Location: KOLKATA
|
Member |
|
|
Just to clear my doubt. My temporary tablespace temp is of 40G and the HWM also shows 40G. At this moment free space is also 40G. Now if I ran a SQL statement that nees the temp for sorting
will the temp tablespace available. Bit confused for the HWM
|
|
|
Re: TEMP TABLESPACE [message #445467 is a reply to message #445462] |
Tue, 02 March 2010 00:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Temporary tablespace are not used like other ones.
See Database Concepts
Chapter 2 Data Blocks, Extents, and Segments
Section Overview of Segments
Paragraph Introduction to Temporary Segments
Chapter 3 Tablespaces, Datafiles, and Control Files
Section Overview of Tablespaces
Paragraph Temporary Tablespaces for Sort Operations
Extents are created in tablespace by the instance when they are needed and they are NEVER feed until the end of the instance but they can be reallocated for other operations than the one that saw its creation.
Regards
Michel
|
|
|