RE: Resizing a file with two //

Before you do the rename command, do :
1-shutdown immediate
2-startup mount
3-move the file at the OS level to what you want the new name to be <<db
must be in mount mode>>
4-then issue "alter database rename file "/u03//..." to "/u03/...";
 
 
____________________________________________________
Theresa Corral-Steele
Sr. Oracle DBA, MDS I.T. Services, Irvine, CA 
949-450-8345 ext. 415
949-677-8925 (mobile)
 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ram Raman
Sent: Thursday, July 27, 2006 3:15 PM
To: saibabu_d@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Resizing a file with two //


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
        --
        http://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.


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.

Other related posts: