Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Impossible to move tempfile

Re: Impossible to move tempfile

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Tue, 14 Nov 2006 22:33:04 GMT
Message-ID: <J8qrz6.Lx@igsrsparc2.er.usgs.gov>


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" - Unknown
Received on Tue Nov 14 2006 - 16:33:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US