Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Temp tbs with no temp file

Re: Temp tbs with no temp file

From: Mladen Gogala <mgogala_at_allegientsystems.com>
Date: Fri, 01 Jul 2005 08:48:52 -0400
Message-ID: <42C53BB4.4020603@allegientsystems.com>


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
Received on Fri Jul 01 2005 - 08:51:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US