Re: Resizing a file with two //

From: Saibabu Devabhaktuni <saibabu_d_at_yahoo.com>
Date: Thu, 27 Jul 2006 15:06:12 -0700 (PDT)
Message-ID: <20060727220612.26381.qmail@web56001.mail.re3.yahoo.com>

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

Received on Thu Jul 27 2006 - 17:06:12 CDT