Re: Extent management local problem

On Fri, 2 May 2003 09:10:00 +0100, "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:

>"Peter" <peter_at_nomorenewsspammin.ca> wrote in message
>news:4mt2bvcbpn5vs4sm23pna79tp8bsgf8e3c_at_4ax.com...
>
>> But the following won't work for locally managed, still don't know
>> why:
>>
>> CREATE TABLESPACE temp
>> DATAFILE 'c:\oracle\oradata\db2\temp.dbf' SIZE 100M
>> EXTENT MANAGEMENT local
>> TEMPORARY;
>>
>> My question is that why is a locally managed temporary tablespace
>> shown as a data file in the dba_data_files table, but not as a temp
>> file in dba_temp_files table?
>
>Datafile specifies a datafile,tempfile specifies a tempfile - clever huh?

Why is a temporary file treated as a datafile? Why is it designed this way? A temporary file created with a datafile clause, and then listed as a datafile. It should be created with a tempfile clause instead and listed as a tempfile. Received on Fri May 02 2003 - 04:48:48 CDT