Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 - 05:44:43 CDT