Re: Moving instance to another host

bill_at_asplundh.com wrote:
>
> >B) FTP the data files to the new host, copy the data files to the
> >corresponding
> > directories, edit the Control File and startup the instance.
>
> I have been doing this by export/import and I am not sure how to do it
> through file copy, edit control file ????
>
> How do you edit the control file ? What changes need to be made ?
>
> Thanks in advance,
>
> Bill Timm
> Asplundh Tree Expert Co.
> bill_at_asplundh.com

Bill,

to edit a controlfile you have to do following: 1. alter database backup controlfile to trace;

   this will produce a create controlfile statement in the trace    directory.

2. Edit this trace file
3. start your database with the nomount option
4. run your create script

after this steps you will have new controlfiles.

WARNING : Backup controlfiles before you change this files

-- 
Detlev Goebel

detlev.goebel_at_gzs.de
********************