Re: newbie : how move a database from a machine to another ?

From: Brian Wheeler <brian.wheeler_at_iname.com>
Date: Sun, 23 Jan 2000 06:08:15 GMT
Message-ID: <388A9897.30AF4044@iname.com>

You didn't say what kind of 'old' machine the original database was on. If it was NT as well, then if you set up the disk devices the same on the new NT server then you could just copy the database file over.

You would have to create the instance on the new machine, using the oradim80 utility, and be sure to copy the init.ora, control files, and orapwd files as well.

If it wasn't NT, then you would have to use the import/export routines.

Good luck
Brian Received on Sun Jan 23 2000 - 00:08:15 CST