Re: oracle 9i problems.. renaming datafiles

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Wed, 19 Jun 2002 19:07:12 +0200
Message-ID: <3D10BA40.B75B3CDB@mytoys.de>

mikeDesouza wrote:

> I am trying to rename a datafile in oracle 9 release 1. I perform the
> following steps but somehow it fails and i have to perform media recovery .
> when I try and rename the datafile its say that some process is using in ,
> so when i try and bring it online it says it needs media recovery

AFAIK you can't rename the file when the database is open. Shutdown the instance, startup mount, rename the file (on OS level *and* in the database) and open the db.

Regards,

Knut Received on Wed Jun 19 2002 - 12:07:12 CDT