Re: Resizing a file with two //

use rman to switch name works for all cases. rman copy, offline datafile file#, swithc in rman. recover in rmn, online in rman.

I hit that problem before, rename in sqlplus does not work for my case.

On 7/28/06, Ram Raman <veeeraman_at_gmail.com> wrote:
>
> Thanks. It does not work for me:
>
> 16:57:29 SQL> alter tablespace TOOLS rename datafile
> '/u03//oradbs/abcd/tool_abcd.dbf' to
> 17:08:51 2 '/u03/oradbs/abcd/tool_abcd.dbf';
> alter tablespace TOOLS rename datafile '/u03//oradbs/abcd/tool_abcd.dbf'
> to
> *
> ERROR at line 1:
> ORA-01525: error in renaming data files
> ORA-01522: file '/u03//oradbs/abcd/tool_abcd.dbf' to be renamed does not
> exist
>
>
> 16:57:29 SQL> alter tablespace TOOLS rename datafile
> '/u03//oradbs/abcd/tool_abcd.dbf' to
> 17:08:51 2 '/u03/oradbs/abcd/tool_abcd.dbf';
> alter tablespace TOOLS rename datafile '/u03//oradbs/abcd/tool_abcd.dbf'
> to
> *
> ERROR at line 1:
> ORA-01525: error in renaming data files
> ORA-01522: file '/u03//oradbs/abcd/tool_abcd.dbf' to be renamed does not
> exist
>
>
>
>
>
> 17:13:46 SQL> select FILE_NAME from dba_data_files
> 17:13:54 2 where TABLESPACE_NAME = 'TOOLS';
>
> FILE_NAME
>
> --------------------------------------------------------------------------------
>
> /u03//oradbs/abcd/tool_abcd.dbf
>
>
> ----------------------------------------------------
>
>
> --
> Regards
> Zhu Chao
> www.cnoug.org
>
>

--
http://www.freelists.org/webpage/oracle-l