Resizing a file with two // 2006-07-27 - By Ram Raman
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 (See ORA-01516.ora-code.com): 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.
<div>Hi,</div>
<div> </div>
<div>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
</div>
<div> </div>
<div>"ORA-01516 (See ORA-01516.ora-code.com): nonexistent log file, datafile, or tempfile"</div>
<div> </div>
<div>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
"/".</div>
<div> </div>
<div>Oracle: 10.2 on Solaris 8</div>
<div> </div>
<div>Ram.</div>
|
|
