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: http://www.or
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 redo
(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
Subject
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:04To: Multiple recipients of list
ORACLE-LSubject: Moving datafiles, controlfiles, and
redos.
Hi G