Re: Control file relocation

You have several options.

• You can create init.ora and spfiles while your database is down, fro meach other. So you can just create init.ora file, make change, create spfile, remove init.ora file, startup normal.
• You can also make the change ahead of time via alter system set control_files = ... scope=spfile;

then bounce.

Christo Kutrovsky
Database/System Administrator
The Pythian Group

On Tue, 29 Mar 2005 13:58:51 -0500, Seema Singh <oracledbam_at_hotmail.com> wrote:
> Hi,
> How to relocate controlfile in 9i thru spfile?
> thanks
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
http://www.freelists.org/webpage/oracle-l