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
    --
    http://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 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: