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 -> Extent management local problem

Extent management local problem

From: Peter <peter_at_nomorenewsspammin.ca>
Date: Thu, 01 May 2003 10:44:43 GMT
Message-ID: <jfu1bv8988c8tvr8hguo5ditv9a2ifnv4d@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? Received on Thu May 01 2003 - 05:44:43 CDT

Original text of this message

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