While in mount mode, move the OS file to the newly name file. And then the rename command will work. The message is correct. Until renamed at OS level, the file does not exist. ____________________________________________________ Theresa Corral-Steele Sr. Oracle DBA, MDS I.T. Services, Irvine, CA 949-450-8345 ext. 415 949-677-8925 (mobile) -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Saibabu Devabhaktuni Sent: Thursday, July 27, 2006 3:37 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: Resizing a file with two // Are you sure that there are no hidden characters in that filename. you may want to run the following query: select ':'||file_name||':' from dba_data_files where tablespace_name='TOOLS'; Thanks, Sai http://sai-oracle.blogspot.com * From: "Ram Raman" <veeeraman@xxxxxxxxx> * To: saibabu_d@xxxxxxxxx * Date: Thu, 27 Jul 2006 17:15:09 -0500 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 ---------------------------------------------------- On 7/27/06, Saibabu Devabhaktuni <saibabu_d@xxxxxxxxx> wrote: It works for me on 8i, if resize doesn't work on 10g, atleast rename should work. 14:56:07 SQL> create tablespace test2 datafile '/oracle/TEST//data54/TEST/test2_01.dbf' size 100M; Tablespace created. 14:56:37 SQL> select name from v$datafile where name like '%//%'; NAME ---------------------------------------------------------------------- /oracle/TEST//data54/TEST/test2_01.dbf 14:56:56 SQL> alter database datafile '/oracle/TEST//data54/TEST/test2_01.dbf' resize 200M; Database altered. 14:57:11 SQL> alter tablespace test2 offline; Tablespace altered. 14:57:21 SQL> alter database rename file '/oracle/TEST//data54/TEST/test2_01.dbf' 14:57:38 2 to 14:57:40 3 '/oracle/TEST/data54/TEST/test2_01.dbf'; Database altered. Thanks, Sai http://sai-oracle.blogspot.com * From: "Ram Raman" <veeeraman@xxxxxxxxx> * To: oracle-l@xxxxxxxxxxxxx * Date: Thu, 27 Jul 2006 16:45:14 -0500 Hi, We have a file in a database with two slashes in its name: "/u03//oradbs/abcd/tool_abcd.dbf". I dont know how that file was created, but I inherited that database. The tablespace is full now. I would like to resize the file to a bigger size, but resize command fails with "ORA-01516: nonexistent log file, datafile, or tempfile" I can add a new file, but I prefer straightening out the name of this file. Does anyone know how to rename this file properly with just one "/". Oracle: 10.2 on Solaris 8 Ram. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l * References: o Re: Resizing a file with two // + From: Saibabu Devabhaktuni __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l This email and any files transmitted with it may contain privileged or confidential information and may be read or used only by the intended recipient. If you are not the intended recipient of the email or any of its attachments, please be advised that you have received this email in error and any use, dissemination, distribution, forwarding, printing or copying of this email or any attached files is strictly prohibited. If you have received this email in error, please immediately purge it and all attachments and notify the sender by reply email or contact the sender at the number listed. -- //www.freelists.org/webpage/oracle-l