Re: Resizing a file with two //

From: Ram Raman <veeeraman_at_gmail.com>
Date: Thu, 27 Jul 2006 17:15:09 -0500
Message-ID: <effc058d0607271515v6a5649fl6ec1d6425176621d@mail.gmail.com>

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

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_at_yahoo.com> 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_at_xxxxxxxxx>
> * To: oracle-l_at_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
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 27 2006 - 17:15:09 CDT