Re: Move Oracle NT to different drive!

From: Joe Brown <joe_at_hopi.dtcc.edu>
Date: 6 Nov 1998 17:43:21 GMT
Message-ID: <71vcfp$hb5$1@apache.dtcc.edu>

Oops: forgot to mention control files...

do
alter database backup controfile
(to text) before adding the drive...
(good idea to have a backup of this file anyway...)

Don't forget to update the initSID.ora (initorcl.ora) and set the new location of the control files, if they changed, also.

In article <36431bca.8497208_at_news.globalnet.co.uk>, Adrian Harrison <adrianh_at_globalnet.co.uk> wrote:
>I currently have Oracle 7.3 for NT installed on an NTFS partition (I:) on a SCSI drive
>
>I want to install a second IDE drive and know from previous experiences messing about with IDE &
>SCSI drives in the same system that Oracle's partition letter will change! - probably to O:
>
>Firstly is there a migration facility available to do this?
>
>If not and I reinstalled Oracle to the L: drive can I just copy the old datafiles across? - if so
>which ones?
>
>Thanks
>
>Adrian Harrison

--
(: Joe Brown :) joe_at_apache.dtcc.edu I believe Wine is going to be great if it ever gets finished. . . I believe Linux _is_ great even though it's not finished! ! ! I believe you have my address. :-) Received on Fri Nov 06 1998 - 11:43:21 CST