Re: inc. size of temp tablespace

From: Luc Gyselinck <Luc.Gyselinck_at_nospampandora.be>
Date: Mon, 07 Jun 2004 21:10:21 GMT
Message-ID: <1R4xc.147874$GE.7582786@phobos.telenet-ops.be>

Is it a DATAFILE or a TEMPFILE ? Temporary tablespaces can (as of Oracle8i) be created with DATAFILEs or TEMPFILEs.

SQL> alter database tempfile '/oracle/SND/sapdata1/temp/temp1.data' resize 200M;

"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?
>
> sapsnd:orasnd 32> pwd
> /oracle/SND/sapdata1/temp
> sapsnd:orasnd 33> ls -lt
> total 200848
> -rw-rw-rw- 1 orasnd dba 104865792 Jun 7 15:41 temp1.data
>
> Here is what I am running:
>
> SQL> select * from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
> PL/SQL Release 9.2.0.4.0 - Production
> CORE 9.2.0.3.0 Production
> TNS for HPUX: Version 9.2.0.4.0 - Production
> NLSRTL Version 9.2.0.4.0 - Production
>
> In other words, what is the easiest way to increase the size
> of the temporary tablespace?
>
> Thanks!
> Vince
>
> p.s. Tried:
> SQL> alter tablespace psaptemp1
> 2 add datafile '/oracle/SND/sapdata1/temp/temp1.data2' size 200M;
> alter tablespace psaptemp1
> *
> ERROR at line 1:
> ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
>
Received on Mon Jun 07 2004 - 16:10:21 CDT