Re: Resizing a file with two //
- From: Saibabu Devabhaktuni <saibabu_d@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 27 Jul 2006 15:06:12 -0700 (PDT)
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:
