Re: Working with the Control Files

I'm not totally sure on this one, but if you could copy it then definitly not when the database is up and running. If you change the location of the control-file you have to change the initSID.ora since there's where the location of your control-files is described. The control-file itself, contains among other things the location of database- and redolog files, so you don't want to move these without altering your control files the right way (which is the ORACLE-ALTER way)

Hope this answers your question.

Reinier.

Keth <kslaton_at_newsguy.com> wrote in message news:hnpntsokb8k1bfj62uenb8nia60no80l50_at_4ax.com...
> Could there ever be a competent newbe question? Oh well
>
> My question is this when working with control files I understand that
> I must use the alter database command to create a human readable text
> file. But would it be possible to just copy the file from one
> directory to another? Oh and would I need to do this durning system
> maintenance or could I copy the file at anytime.
>
> Thanks in advance
Received on Thu Oct 05 2000 - 03:55:56 CDT