As all my tablespaces were more or less full I found the following command useful:
alter tablespace temp add tempfile 'C:\ORACLEXE\ORADATA\XE\TEMP1.DBF' SIZE 500Musing a different path.
I found this and much more helpful info on this page
Clear step by step descriptions of setting up and completing various IT tasks, explained and documented just as they've been done
alter tablespace temp add tempfile 'C:\ORACLEXE\ORADATA\XE\TEMP1.DBF' SIZE 500M
No comments:
Post a Comment