Error renaming datafile with embedded blank in the file name
One of our jr. dba's created a datafile in one of our databases (EE 11.2.0.3 on Linux RH). The file was put in the wrong directory, so I want to move it, but she also created the datafile with an embedded blank in the file name. I have taken the tablespace offline and am executing the following with the error returned below. The /usr/orasys11.11.2.X/dbs and /oradata/PRDARCH1/data1 directory's definitely exist and oracle is the owner.
SQL> alter tablespace datamart_data_1m rename datafile '/usr/orasys11/11.2.X/dbs/DATAMART_DATA_1M _45.dbf' to '/oradata/PRDARCH1/data1/DATAMART_DATA_1M_45.dbf';