|
[oracle-l]
||
[Date Prev]
[07-2005 Date Index]
[Date Next]
||
[Thread Prev]
[07-2005 Thread Index]
[Thread Next]
Re: Temp tbs with no temp file
- From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
- To: all_about_oracle@xxxxxxxxxx
- Date: Fri, 01 Jul 2005 08:48:52 -0400
Sinardy wrote:
But why it allow the tablespace without datafile.
The 10g Concept said:
Databases, tablespaces, and datafiles are closely related, but they
have important differences:
*
An Oracle database consists of one or more logical storage units
called tablespaces, which collectively store all of the
database's data.
Temporary tablespaces do not store any data. Block belonging to
tempfiles are not protected either by redo or
undo. So, temporary tablespace does not fit into this concept. Temporary
tablespaces were created from a
normal tablespace's rib and, therefore, cannot be explained scientifically.
--
Mladen Gogala
Oracle DBA
Ext. 121
--
http://www.freelists.org/webpage/oracle-l
|
|
