| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Temporary Tablespaces
Major differenc is a temporary tablespace does not get logged in the redo logs, and thus a performance gain on writes.
-----Original Message-----
To: Multiple recipients of list ORACLE-L
Sent: 5/20/01 9:15 PM
Greetings to All,
I am interested to know what the difference between a tablespace that is "created as temporary" and a "temporary tablespace" is. I am using 8.1.6.3.0.
There are two commands that can be used ...
create tablespace ...... temporary;
and
create temporary tablespace ....;
According to the Oracle documentation ...
A tablespace that is created as temporary (ie. create tablespace ... temporary) is used to hold temporary objects eg. segments used by implicit sorts to handle order by clauses. Also if you specify temporary you cannot specify EXTENT MANAGEMENT LOCAL.
Whereas a temporary tablespace (ie. create temporary tablespace ...) is used to contain schema objects for the duration of a session. And you can specify EXTENT MANAGEMENT LOCAL.
Can anyone enlighten me as to whether these two constructs are the same thing! I am assuming they are the same and are used for storing temporary session objects and sort segments and the only difference is that you can only create a locally managed temporary tablespace with one of them.
Or, is the "create tablespace ... temporary" there for backwards compatibility?? A the "create temporary tablespace" is the new way to do things??
TIA Glen
--
Glen Mitchell NZ Phone: +64 9 3730400 Energy Research Lab URL: http://www.peace.com<http://www.peace.com>
Peace Software Email: glen.mitchell_at_peace.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
INET: cspence_at_FuelSpot.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sun May 20 2001 - 20:54:52 CDT
 |
 |