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
