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@xxxxxxxxxxx> wrote: > Hi, > How to relocate controlfile in 9i thru spfile? > thanks > > -- > //www.freelists.org/webpage/oracle-l > -- Christo Kutrovsky Database/System Administrator The Pythian Group -- //www.freelists.org/webpage/oracle-l