Impossible to move tempfile

Giganews Newsgroups
Subject: Impossible to move tempfile
Posted by:  astalavista (nobo…
Date: Tue, 14 Nov 2006


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

SQL> select name from v$tempfile;




Database in mount state:

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

SQL> alter database rename file

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

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



ERROR at line 1:

ORA-01511: error in renaming log/data files

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


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

-rw-r-----  1 oracle9  dba        41951232 Oct 06 22:58