Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Cannot rename tempfile
Hi,
I try to rename files from a database
the database is in mount state
it is OK for all datafiles
but for tempfiles I got the error below:
alter database rename file '/prd/data/ora/P200/02/P200_temp01.dbf' to
'/prd/data/ora/P200/02/P100_temp01.dbf'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, datafile, or tempfile
"/prd/data/ora/P200/02/P200_temp01.dbf"
I am sure the files exist.
Bug or feature ?
Thanks for your lights
9.2.0.6/AIX 5.3
Received on Thu Nov 29 2007 - 14:33:22 CST
![]() |
![]() |