Hi Glen,
A tablespace created with the CREATE TEMPORARY TABLESPACE command uses tempfiles
instead of datafiles, and as such is often called a tempfile tablespace. A
tempfile tablespace is equivalent to a locally managed datafile tablespace with
temporary contents, except that tempfiles do not
Hi Steve,
Is there any disadvantage to using a tempfile tablespace for the TEMPtablespaces
used by the application? Apart from the fact that they are non-recoverable.
In the past Ihave created TEMPtablespaces with datafiles.
I suppose the nature of the temp tablespace is that it contains
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
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