Problem renaming a Tablespace Datafile in 10.2.0.4

I have a tablespace called EXT_DATA which has 4 datafiles. When I created the 4th datafile I accidentally prefixed it with a period and want to remove this as it is causing issues with my backup scripts. I brought the tablespace offline and issued the following command.

alter tablespace ext_data rename datafile '/data1/oradata/ oranc1/.ext_data_4.dbf' to '/data1/oradata/oranc1/ext_data_4.dbf';

However, it does not work as the period causes issues.

alter tablespace ext_data rename datafile '/data1/oradata/ oranc1/.ext_data_4.dbf' to '/data1/oradata/oranc1/ext_data_4.dbf' *
ERROR at line 1:
ORA-01525: error in renaming data files
ORA-01141: error renaming data file 15 - new file '/data1/oradata/oranc1/ext_data_4.dbf' not found ORA-01110: data file 15: '/data1/oradata/oranc1/.ext_data_4.dbf' ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory Additional information: 3

I'm sure there is a simple answer to renmaing this datafile but I simply can't find it. Any offers off assistance would be greatly appreciated.

Thanks in advance Received on Mon Jan 11 2010 - 08:40:47 CST