Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving .dbf file from one moun to other mount
Dusan Bolek wrote:
>
> 1. shutdown database
> 2. move your file from its current destination to the second one
> 3. startup nomount
> 4. alter database rename datafile '/oracle/data/file.dbf' to
> /ora/file.dbf';
> 5. alter database open
>
> That's all.
>
We live and learn. I always thought for rename datafile you need to mount the database?
Regards,
Holger Received on Mon Sep 20 2004 - 09:18:31 CDT