Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Impossible to move tempfile
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
>
>
>
>
I had the same exact issue when trying to move a tempfile some time ago. I just recreated a new temp tablespace in the new location and then dropped the old one.
HTH,
Brian
-- =================================================================== Brian Peasland dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Tue Nov 14 2006 - 16:33:04 CST