Copy Oracle 9 db/instance from one machine to another?
Posted on 2008-09-29
I have Oracle 9i Enterprise Edition Release 126.96.36.199.0 installed on two machines running Solaris. I want to copy a production database from one server to another.
What is the simplest way to copy the production database over using the same instance name, user name, and password?
The production machine is currently two Oracle instances and the backup machine is running one (unrelated to the new one I want to move over).