Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> [Oracle 8.05] How could I move the temp datafile?
The problem is that I have datafile named 'Temp1.ora' and its size is
already 2.8GB
while the drive where this datafile is placed has only 30 MB. I want to
move this
datafile to another place without database shutdown. Or should I rather
re-create
a fresh temp datafile with temporary tablespace in another location?
Need help please.
Thanks in advance.
Shin
Received on Mon Feb 20 2006 - 08:32:36 CST