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.
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