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: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
