Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Export/Import oracle 10g db to another machine
Hello,
I have been doing some research these few days and have kind of find what I need to do, that is export and import oracle db to another machine by using exp/imp/oradim functions. But using the oradim function to create the service, you do not have the web interface that is generated when using Database Configuration Assistant to create the database.
Having been working with MySQL, MSSQL, Sybase and to lesser extend DB2,
you can easily transport the database over to another machine, with
minimal configuration required. What I have done, by copying the other
db export/import technique, is create the oracle db instance using
Database Configuration Assistant, then shut down the service via
services.msc, copy over all the log files, control files and data files
to the new instance data directory
(C:\oracle\product\10.2.0\oradata\<instance>\) on the new machine.
Then, restart the service and woala, the transport worked! Doing this
you also get the web interface too.
Has anyone done what I just described above? Is this method safe? I cannot find any tips and tricks anywhere which recommends you to do what I did in Oracle.
Also, why is everything in Oracle seems to be 10x harder?
Thank you. Received on Mon Nov 27 2006 - 18:22:40 CST