I believe this is the expected behaviour. You can either drop and
recreate the tablespace or the tempfiles
--Renzo
astalavista wrote:
> 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 - 15:20:48 CST
