Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Temporary Tablespaces
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 3730400Energy Research Lab URL: http://www.peace.com
Peace Software Email: glen.mitchell_at_peace.comReceived on Sun May 20 2001 - 19:27:27 CDT
![]() |
![]() |