Re: Cannot rename some datafiles

From: Jerome Vitalis <vitalismanN05P4M_at_gmail.com.invalid>
Date: 24 Oct 2007 20:24:32 GMT
Message-ID: <471faa00$0$16957$79c14f64@nan-newsreader-07.noos.net>

On Wed, 24 Oct 2007 21:26:47 +0200, astalavista wrote:

> Hi,
>
> I rename about 50 datafiles
> (database in mount state)
> some datafiles can't be renamed
> I don't know why
> Can you help me ?
> (9.2.0.6)
>
> Thanks in advance
>
>
> SQL> /
> alter database rename file '/prd/data/ora/P95/03/P95_dwh_dat11.dbf'
> to '/prd/data/ora/P100/03/P100_dwh_dat11.dbf' *
> ERROR at line 1:
> ORA-01511: error in renaming log/data files ORA-01516: nonexistent log
> file, datafile, or tempfile "/prd/data/ora/P95/03/P95_dwh_dat11.dbf"
>
>
> SQL> !ls -l /prd/data/ora/P95/03/P95_dwh_dat11.dbf -rw-r----- 1 oracle
> dba 2095939584 Oct 24 14:48
> /prd/data/ora/P95/03/P95_dwh_dat11.dbf
>
> SQL> !ls -l /prd/data/ora/P100/03/P100_dwh_dat11.dbf -rw-r----- 1
> oracle dba 2095939584 Oct 24 12:30
> /prd/data/ora/P100/03/P100_dwh_dat11.dbf

Is it in v$datafile? Received on Wed Oct 24 2007 - 15:24:32 CDT