Copying data files on another machine
Posted on 2008-11-01
I always wondered why simply copying Oracle data files to another machine is not sufficient to make Oracle work. Consider Microsoft SQL Server, in case you need to attach an existing database to an SQL Server instance running on another machine, simply copy two files viz. .mdf and .ldf to another machine. Whereas in Oracle I tried many times but it didn't work.
In case I don't have backup of the database and I want to copy this database to another machine running Oracle, how will I be able to do so?