RE: Moving datafiles, controlfiles, and redos.

2002-11-04 Thread Scott Stefick
(T)hanks (I)n (A)dvance At 09:48 AM 11/4/02 -0800, you wrote: sorry what is that TIA thing on the ned of the message -Original Message- From: Gabriel Aragon [mailto:[EMAIL PROTECTED]] Sent: segunda-feira, 4 de Novembro de 2002 17:04 To: Multiple recipients of list ORACLE-L

RE: Moving datafiles, controlfiles, and redos.

2002-11-04 Thread Fink, Dan
TIA - Thanks In Advance... What is the 'ned of the message' -Original Message-From: Paulo Gomes [mailto:[EMAIL PROTECTED]]Sent: Monday, November 04, 2002 10:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Moving datafiles, controlfiles, and redos. sorry

RE: Moving datafiles, controlfiles, and redos.

2002-11-04 Thread Stephen Lee
If you are, in fact, moving the files to different file systems: Change the location of the control files in the init.ora. Startup mount. alter database rename file '/from/where/it/was' to '/where/it/is/now'; etc. etc. alter database open; -- Please see the official ORACLE-L FAQ: