Re: Resizing a file with two //
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: veeeraman@xxxxxxxxx
- Date: Fri, 28 Jul 2006 00:12:10 +0200
hm... perhaps, you can try to use file# instead of the name.
What's error do you get when renaming a datafile?
2006/7/27, Ram Raman <veeeraman@xxxxxxxxx>:
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.
--
Best regards,
Alex Gorbachev
http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l
- References:
- Resizing a file with two //
- From: Ram Raman
Other related posts:
- » Resizing a file with two //
- » Re: Resizing a file with two //
- » Re: Resizing a file with two //
- » Re: Resizing a file with two //
- » Re: Resizing a file with two //
- » RE: Resizing a file with two //
- » RE: Resizing a file with two //
- » Re: Resizing a file with two //
- » Re: Resizing a file with two //
- » Re: Resizing a file with two //
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.
- Resizing a file with two //
- From: Ram Raman