Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: moving control files
Edit the init.ora. Shutdown the database. Move the files. Startup the
database. I wouldn't use instance manager. You can't change them
dynamically.
Jim
"dsmcd" <dsmcd_at_uswestmail.net> wrote in message
news:YEAR7.266$a47.241199_at_news.uswest.net...
> Hello...
>
> Trying to move my control files from their default positions.
>
> Tried using Instance Manger in the All Parameters window. logged on as
> Internal, System, and Sys. The values are not available for changing.
>
> Tried editing init.ora, and editing def_sid.ora. Neither had any effect
> (according to the All Parameters window, which still showed all control
> files in the same default place). Tried this with (and without) moving
> the control files to the specified place.
>
> Default Oracle install (8.1.7). Default database creation.
>
> Any suggestions?
>
> Thx,
> D.
>
>
Received on Tue Dec 11 2001 - 22:27:50 CST