Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Extent management local problem

Re: Extent management local problem

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 1 May 2003 07:11:25 -0700
Message-ID: <2687bb95.0305010611.469db163@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?

What version of Oracle? You need to be at least 8.1 to use locally managed talbespaces. Also don't you want to use: create temporary tablespace temp using tempfile instead?

See the SQL manual entry for "create tablespace"

HTH -- Mark D Powell -- Received on Thu May 01 2003 - 09:11:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US