Re: inc. size of temp tablespace

Thanks. I love google and of course found the solution after posting (which happens ALL the time - just when I think I have googled enough)

On Tue, 8 Jun 2004 07:05:59 +1000, "Howard J. Rogers" <hjr_at_dizwell.com> wrote:

>
>"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;
Received on Tue Jun 08 2004 - 08:24:27 CDT