Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Moving databases between disks on NT Server 4.0

Re: Moving databases between disks on NT Server 4.0

From: Reid Lai <reidlai_at_hk.super.net>
Date: Thu, 17 Dec 1998 00:00:05 +0800
Message-ID: <3677D904.41F2B933@hk.super.net>


First of all, you have to shut down the database instance. Copy all files including datafiles, redo log files, archive log files, control files, etc. to your new disk. Change all parameters related to your drive mapping in INIT.ORA or something like this. Startup the database with mount option. Issue ALTER DATABASE ...RENAME DATAFILE 'your old file' TO 'your new file' for all datafiles and redo log files. If everything is O.K., open the database for testing and shutdown again for backup. Hope this can help you.

Merlin Team wrote:

> Hi,
>
> I have a problem that I have two databases on drive d:\ on an NT box, I am
> now running short of space on the drive but have masses of space available
> on the e:\ drive.
>
> What steps are needed to move one of the databases from the d:\ drive to the
> e:\ drive?
>
> Thanks
>
> Paul
> paul_merlin_at_hotmail.com

--
Best Regards,

Reid Lai <reidlai_at_hk.super.net>
Oracle 7.3 Certified Database Administrator (OCP)



The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Dec 16 1998 - 10:00:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US