Re: Resizing a file with two //

  • From: "Zhu,Chao" <zhuchao@xxxxxxxxx>
  • To: veeeraman@xxxxxxxxx
  • Date: Sat, 29 Jul 2006 12:11:22 +0800

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@xxxxxxxxx> 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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2006