Re: Resizing a file with two //

Thanks all who replied.

I was able to increase the size of the file using Alex's approach, but I was
not able to rename it.  I can try Chao's method Monday.


On 7/28/06, Zhu,Chao <zhuchao@xxxxxxxxx> wrote: 

 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: