| 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
Yes, Oracle will completely ignore the tempfile in terms of logging. You cannot use LMT on a temporary tablespace, but you can do it on a tempfile. You cannot make a temp file read only or move it which is another diference with temporary tablespaces (temp files). Control file and DBA_DATA_FILE do not say anything about temporary tablespaces (temp files). I think part of the reason was Oracle found it easier to make a new object than try to make an exception and have temp tablepace clause total ignore redo.
-----Original Message-----
To: Christopher Spence
Sent: 5/20/01 9:58 PM
Hi Christopher,
I am assuming you mean the "create temporary tablespace ..." does not generate redo activity?
The "create tablespace ... temporary" can be created with a NOLOGGING option which only applies to certain DDL operations on objects within that tablespace.
So, how is that different from the "create temporary tablespace ..."?
Christopher Spence wrote:
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
--
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 - 22:22:04 CDT
 |
 |