Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reducing Temp Tablespace

227393May 14 2008 — edited May 15 2008
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 12 2008
Added on May 14 2008
3 comments
849 views