Re: Moving Oracle Home

No,

You will have to install the Oracle executables to the new Oracle_home. Once in the new Oracle home move the datafiles, init.ora and controlfiles to the new database home directory, if there are only 7-8 datafiles then recreate the instance for the new location using ORADIM73 command line. Then mount the database and issue:

 alter database rename file 'oldpath\filename' to 'newpath\filename';

This will rename the locations of the files so the controlfile can locate them.
If you have a lot of datafiles, mount the database and issue:

 alter database backup controlfile to trace;

In your trace directory you will have the create syntax for a new controlfile. Edit that file to change the datafile paths. Then you can save the file as a .SQL script.
Startup nomount and execute the new controlfile script.

Good luck.

Armadillo_at_my-dejanews.com wrote in article <6pps8i$ptb$1_at_nnrp1.dejanews.com>...
> I have an instance on an NT box in which we have
> just installed a new (i.e. additional) hard drive,
> and for various reasons want to move oracle home
> to the new drive. Is there any way to do this on
> NT without de-installing and re-installing all the
> oracle software (running version 7.3.2)?
>
> Julian Wiffen
>
> jwiffen_at_zsassociates.com
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Mon Aug 10 1998 - 06:44:43 CDT