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: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 1 May 2003 12:04:55 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7039F0B64@lnewton.leeds.lfs.co.uk>


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.



Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk
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

Original text of this message

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