Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Temp file question
I have a stupid question. I did following to move a temp file:
(1) alter database tempfile '/old_dir/mytempfile1' offline;
(2) moved tempfile to new directory in OS.
(3) alter database rename file '/old_dir/mytempfile1' to
'/new_dir/mytempfile1';
When i run (3), oracle says following:
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, datafile, or tempfile
"/old_dir/mytempfile1"
What should I do? Ths database version is 10.1.0.3.0 running on HPUX Received on Wed Dec 14 2005 - 20:03:44 CST
![]() |
![]() |