Re: Resizing a file with two //

From: Saibabu Devabhaktuni <saibabu_d_at_yahoo.com>
Date: Thu, 27 Jul 2006 15:37:10 -0700 (PDT)
Message-ID: <20060727223710.25672.qmail@web56006.mail.re3.yahoo.com>

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_at_xxxxxxxxx>
To: saibabu_d_at_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

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_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_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

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

Received on Thu Jul 27 2006 - 17:37:10 CDT