FreeLists / oracle-l / Re: Temp tbs with no temp file

["Sinardy" <all_about_oracle@xxxxxxxxxx>]

But why it allow the tablespace without datafile.

The 10g Concept said:
Databases, tablespaces, and datafiles are closely related, but they have 
important differences:

  a.. An Oracle database consists of one or more logical storage units called 
tablespaces, which collectively store all of the database's data.

  b.. Each tablespace in an Oracle database consists of one or more files 
called datafiles, which are physical structures that conform to the operating 
system in which Oracle is running.

  c.. A database's data is collectively stored in the datafiles that constitute 
each tablespace of the database. For example, the simplest Oracle database 
would have one tablespace and one datafile. Another database can have three 
tablespaces, each consisting of two datafiles (for a total of six datafiles).


My situation, seems like a bit different, don't you think so? Or 

Regards,
Sinardy

----- Original Message ----- 
From: "Mladen Gogala" <gogala@xxxxxxxxxxxxx>
To: <all_about_oracle@xxxxxxxxxx>
Cc: "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, July 01, 2005 6:30 PM
Subject: Re: Temp tbs with no temp file



On 07/01/2005 06:15:19 AM, Sinardy wrote:

> Why Oracle allow to have temporary tablespace without the temp file?

Because tablespace is a logical and not a physical structure.

> 
> What should I do?


Add one.

-- 
Mladen Gogala
Oracle DBA