Reducing Temp Tablespace
227393May 14 2008 — edited May 15 2008Hi,
I need some help with the temp tablespace on an express edition. I have an express edition running under windows 2003 Server and the temp tablespace has increased very large (>4 GB). I have tried to reduce the datafile with 'alter database datafile 'C:\ORACLEXE\ORADATA\XE\TEMP.DBF' resize 2048M;' but I always get the message 'FEHLER in Zeile 1:
ORA-01516: Nicht vorhandene Log-Datei, Datendatei oder temporΣre Datei
'C:\ORACLEXE\ORADATA\XE\TEMP.DBF' even if the path is correct (I have verified it many times).
Is there an possibility to reduce the temp tablespace or is the only possibility to create a new default temp tablespace and delete the old one. If I create a new temp tablespace, can I use the maxsize option?
Many thanks in advance for all your help.
Kind regards
Luis Varon