Re: Howto: Move controlfile in 9i with spfile?

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Wed, 28 Jan 2004 20:46:34 +0800
Message-ID: <4017AF2A.1A1@yahoo.co.uk>

Henk wrote:
>
> Hello,
>
> i want to move one of my three controlfiles to an other filesystem. in
> "old" Instances i have to change this in my init.ora file.
>
> Where i must change it by running spfile? On Instance-Manager this
> parameter is locked.
>
> thx for help!
>
> Henk

alter system set control_file = ... scope=spfile shutdown
copy files
startup

hth
connor

-- 
-------------------------------
Connor McDonald
http://www.oracledba.co.uk
Co-Author: "Mastering Oracle PL/SQL - Practical Solutions"

Received on Wed Jan 28 2004 - 06:46:34 CST