Re: Extent management local problem

From: Brent <bpathakis_at_yahoo.com>
Date: 1 May 2003 08:55:06 -0700
Message-ID: <1736c3ae.0305010755.5dccba3f@posting.google.com>

Peter <peter_at_nomorenewsspammin.ca> wrote in message news:<jfu1bv8988c8tvr8hguo5ditv9a2ifnv4d_at_4ax.com>...
> I ran the folllowing:
>
> CREATE TABLESPACE temp
> DATAFILE ?c:\oracle\oradata\db2\temp.dbf? SIZE 100M
> EXTENT MANAGEMENT LOCAL
> TEMPORARY;
>
>
> How come it does not allow me to use "local"?
> and even when it was created, it is shown as a data file in the
> dba_data_files, but not not a temp file in dba_temp_files?

You may want to try:

CREATE temporary TABLESPACE temp
tempfile 'c:\oracle\oradata\db2\temp.dbf' SIZE 100M extent management local uniform size 1m;

... with uniform size being the same as sort_area_size. Received on Thu May 01 2003 - 10:55:06 CDT