Re: Moving .dbf file from one moun to other mount

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 22 Sep 2004 13:48:28 +0200
Message-ID: <ciroqd$6ri$1@news.BelWue.DE>

Dusan Bolek wrote:
> Holger Baer <holger.baer_at_science-computing.de> wrote in message news:<cimorn$4i5$1_at_news.BelWue.DE>...
>

>>We live and learn. I always thought for rename datafile you need
>>to mount the database?

>
>
> ... and we do mistakes and have memory problems. You're right indeed.
> It would be hard to rename datafile in the phase when a database know
> nothing about them. So the correct sequence is:
>
> 1. shutdown database
> 2. copy your file from its current destination to the second one
> 3. startup mount
> 4. alter database rename file '/oracle/data/file.dbf' to
> /ora/file.dbf';
> 5. alter database open
>

I should have made clear that it was a tongue-in-cheek reply. But I was teaching a oracle for beginners course for a customer the other week, so I was probably a bit pedantic. Speaking of which: It's not exactly necessary to shutdown the database, as Hans kindly pointed out.

Kind regards,

Holger Received on Wed Sep 22 2004 - 06:48:28 CDT