Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Resizing a file with two //

Resizing a file with two //

From: Ram Raman <veeeraman_at_gmail.com>
Date: Thu, 27 Jul 2006 16:45:14 -0500
Message-ID: <effc058d0607271445y3e4c81d2vcc20683474375f23@mail.gmail.com>


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.

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 27 2006 - 16:45:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US