Re: moving control files

Lovely. Worked perfectly. Thank you!

Interesting how this spontaneously altered the def_sid.ora file. Hmm.

Thanks again.
D.

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote:
>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 Wed Dec 12 2001 - 00:14:03 CST