Re: Move Oracle NT to different drive!

With the NT disk manager, you can set drive letters so that they won't change, when a new disk drive is added. Failing that, you can change the drive letters around after adding a new disk drive.

That's the simplest solution I can think of...

OTOH, you can rename oracle datafiles. When the start up of the database fails... or preferable before then, startup the instance with the no mount option.
alter tablespace rename datafile 'old_drive:\location\data.ora' to 'new_drive:\location\data.ora';

I've only used this command once, so you better check the syntax first.

Good luck!

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:37:30 CST