Re: Moving Datafiles

From: N Prabhakar <n_prabhakar_at_post1.com>
Date: 1997/07/31
Message-ID: <01bc9d79$05c56f00$725118d2@sin00119>#1/1

Hello there

Follow the steps.

Shutdown the database.
Use operating system commands to move the files
startup the database by giving startup mount
for each of the files, issue alter database rename file '/disk1/user1.dbf' to '/disk2/user1.dbf' ... ...
alter database open

Backup the database.

Regards

N.Prabhakar

Daniel P. Ritsma <ritsma_at_ibm.net> wrote in article <01bc9a4a$b0499140$990548a6_at_37055.NAC.PW.COM>...
> We are running Oracle 7.3 on a NT4.0 Server station. Our datafiles are
> stored on 2 of our 25 drives, and for tuning reasons I want to move these
> datafiles over more drives. How do I move datafiles over more drives?
>
> I know there is a way to do it something like first copy the files, then
> bring the server up and do an Alter Datafile command. But I would like
to
> be sure before I start.
>
> Thanks for your help.
>
> Ritsma.
>
>
>
Received on Thu Jul 31 1997 - 00:00:00 CDT