Re: Resizing a file with two //

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



Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2006