Re: Extent management local problem

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 2 May 2003 09:10:00 +0100
Message-ID: <3eb227dd$0$4861$ed9e5944@reading.news.pipex.net>

"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?

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Fri May 02 2003 - 03:10:00 CDT