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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Resizing a file with two //

Re: Resizing a file with two //

From: Zhu,Chao <zhuchao_at_gmail.com>
Date: Sat, 29 Jul 2006 12:11:22 +0800
Message-ID: <962cf44b0607282111qc875db2lbb6aa586e8419a36@mail.gmail.com>


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
Received on Fri Jul 28 2006 - 23:11:22 CDT

Original text of this message

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