Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving databases between disks on NT Server 4.0
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)