Impossible to move tempfile

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

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

Replies