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 Peace Software Email: [EMAIL PROTECTED]