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

From: Hans Forbrich <news.hans_at_telus.net>
Date: Mon, 20 Sep 2004 15:27:48 GMT
Message-ID: <UFC3d.93751$XP3.57800@edtnps84>

Holger Baer wrote:

> 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?
> 

Straight from the 9iR2 manual ...

"Use the RENAME FILE clause to rename datafiles, tempfiles, or redo log file members. You must create each filename using the conventions for filenames on your operating system before specifying this clause.

• To use this clause for datafiles and tempfiles, the database must be mounted. The database can also be open, but the datafile or tempfile being renamed must be offline.
• To use this clause for logfiles, the database must be mounted but not open."

Received on Mon Sep 20 2004 - 10:27:48 CDT