Re: inc. size of temp tablespace

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 8 Jun 2004 07:05:59 +1000
Message-ID: <40c4d8a1$0$31677$afc38c87@news.optusnet.com.au>

"Vince Laurent" <vincelaurent_at_sbcglobal.net> wrote in message news:sil9c01bb74it6c15gckhiml4d1agb2ds5_at_4ax.com...
> Why when I do this I get an error:
>
> SQL> alter database datafile '/oracle/SND/sapdata1/temp/temp1.data'
> resize 200M;
> alter database datafile '/oracle/SND/sapdata1/temp/temp1.data' resize
> 200M
> *
> ERROR at line 1:
> ORA-01516: nonexistent log file, datafile, or tempfile
> "/oracle/SND/sapdata1/temp/temp1.data"
>
> when the file and the path exists?

Ah yes, but it's not a datafile, is it, but a "tempfile"?

Hence, you need a command such as:

alter database tempfile 'C:\ORACLE\ORADATA\WIN92\TEMP01.DBF' resize 50m;

Likewise, adding a new file to the temporary tablespace would be done with a command like this:

alter tablespace temp add tempfile 'C:\ORACLE\ORADATA\WIN92\TEMP02.DBF' size 20m;

Regards
HJR Received on Mon Jun 07 2004 - 16:05:59 CDT