Re: Moving a database from one machine to another

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 30 Nov 1999 22:06:35 +0100
Message-ID: <943996079.10332.0.pluto.d4ee154e@news.demon.nl>

alter database backup controlfile to trace This will generate a create controlfile script in your user_dump_dest directory.
Move the files, (as long as there is of course NO os change), edit the script if the locations changed,
run it et c'est tout.

Hth,

--
Sybrand Bakker, Oracle DBA
Adam G. Fisher <agfisher_at_tiac.net> wrote in message news:38443AE4.4F381AF6_at_tiac.net...
> I need to move an Oracle 8 database from one computer to another because
> of some hardware upgrades. I'm going to be running the same version of
> Oracle on the new machine. Whats the proper way to do this? Backup
> then Recovery somehow? Thanks for any help you can give.
>
> Adam Fisher
> Boston, MA.
>
Received on Tue Nov 30 1999 - 15:06:35 CST