Re: Moving database

In <3169D1B4.65BF_at_hal-pc.org> "Carlos A. Gonzalez" <cagosg_at_hal-pc.org> writes:
>
>Help Please :
>
>How do I go about moving Oracle Database from one computer to another
>
>My problem lies with the control files.
>
>No problem in copying the datafile for the logs and the database.
>Also I know I must have an INIT.ORA pointing to the proper *.cntl
 files.
>
>Should I create new cntl files and if so how ???
>
>This is really not a database backup but a move to another
>machine/directory
>
>Any help will be appreciated.
>
>Thanks

If this move is to a new machine do a complete database export and then import it after creating the database on the target machine.

If this move is to a new directory check the FAQ by Kevin Loney at http://www.osborne.com/oracle/ora4.htm

Bhasker Ravikanti. Received on Tue Apr 09 1996 - 00:00:00 CEST