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>
< http://www.peace.com <http://www.peace.com> >
Peace Software Email: [EMAIL PROTECTED]
--
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).
