Re: Moving Oracle data files to a different hard disk

From: flange <flange_at_pt.lu>
Date: 1997/09/22
Message-ID: <01bcc72b$32ef5c80$94d8e4c7@pqh10.ccc.amdahl.com>#1/1

Hi,

	shutdown the database.
	copy the tablespace data file from the current location to the new
location.
	startup mount
	alter database rename file 'oldlocation' to 'newlocation' ;
	alter database open ;

	to move the online redolog.

	alter dabase add logfile newfile_name_location1 ,newfile_name_location2

,...,newfile_name_locationn ;

	alter database drop logfile 'oldlocation1' ;
	alter database drop logfile 'oldlocation2' ;
	alter database drop logfile 'oldlocation..' ;
	alter database drop logfile 'oldlocationn' ;

	If one of these command file you have to switch logfile

		alter system switch logfile ;

	and repeat the stmt for drop

To move the control file

	shutdown database
	in the init.ora 
	change the controlfile location
	copy it from the old to the new location 


	startup db

Regards Francois.
Bill Barnard <wbarnard_at_pechan.com> wrote in article <5vuetd$1a0$1_at_kronos.crosslink.net>...
> I have the starter data base installed and running for Oracle WGS on NT.
 

> However, it was installed on the c: drive and I'd like to move it to the
 d:
> drive because I want to use the starter data base to build a much larger
 data
> base.
>
> What do I need to change/how do I do this?
>
>
>
>
> Bill Barnard
> wbarnard_at_pechan.com
>
  Received on Mon Sep 22 1997 - 00:00:00 CDT