Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Export/Import oracle 10g db to another machine

Export/Import oracle 10g db to another machine

From: Godzilla <godzillaismad_at_gmail.com>
Date: 27 Nov 2006 16:22:40 -0800
Message-ID: <1164673360.221365.175700@j72g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US