Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Extent management local problem
Hi Peter,
you need :
CREATE temporary TABLESPACE temp
tempFILE 'c:\oracle\oradata\db2\temp.dbf' SIZE 100M
EXTENT MANAGEMENT LOCAL
uniform size xxxxx;
cheers,
Norman.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.com
-------------------------------------
-----Original Message-----
From: Peter [mailto:peter_at_nomorenewsspammin.ca]
Posted At: Thursday, May 01, 2003 11:45 AM
Posted To: server
Conversation: Extent management local problem
Subject: Extent management local problem
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 - 06:04:55 CDT