Re: Cannot rename some datafiles

On Oct 25, 12:26 am, "astalavista" <nob..._at_nowhere.com> 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

This issue with quotes (') around the datafile name

do one thing..
copy the script alter database.... to notepad and CHANGE the single quotes on both side of file name
it will work :-)

see:- '/prd/data/ora/P95/03/P95_dwh_dat11.dbf'

I can see that start quotes and end quotes are different.. change it.. it will work

Sunil Bhola

sunilbhola_at_gmail.com Received on Wed Oct 24 2007 - 15:08:17 CDT