Q: inc. size of temp tablespace

From: Vince Laurent <vincelaurent_at_sbcglobal.net>
Date: Mon, 07 Jun 2004 20:55:58 GMT
Message-ID: <sil9c01bb74it6c15gckhiml4d1agb2ds5@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 - 15:55:58 CDT