Impossible to move tempfile

From: astalavista <nobody_at_nowhere.com>
Date: Tue, 14 Nov 2006 21:09:42 +0100
Message-ID: <455a2285$0$30418$426a74cc@news.free.fr>

Hi,

Something weird, I can't move a tempfile, something I miss ? Thannks

9.2.0.7 on AIX 5.3

SQL> select name from v$tempfile;
NAME

/oracle/app/oracle/oradata/DVSAUDIT/temp01.dbf

/base/DVSAUDIT/data/dts101.dbf

Database in mount state:

$ mv /oracle/app/oracle/oradata/DVSAUDIT/temp01.dbf /base/DVSAUDIT/data

SQL> alter database rename file
'/oracle/app/oracle/oradata/DVSAUDIT/temp01.dbf'

to '/base/DVSAUDIT/data/temp01.dbf';

alter database rename file '/oracle/app/oracle/oradata/DVSAUDIT/temp01.dbf' to '

/base/DVSAUDIT/data/temp01.dbf'

ERROR at line 1:

ORA-01511: error in renaming log/data files

ORA-01516: nonexistent log file, datafile, or tempfile

"/oracle/app/oracle/oradata/DVSAUDIT/temp01.dbf"

$ ls -l /base/DVSAUDIT/data/temp01.dbf

-rw-r----- 1 oracle9 dba 41951232 Oct 06 22:58
/base/DVSAUDIT/data/temp01.dbf
Received on Tue Nov 14 2006 - 14:09:42 CST