Menu
i want to transfer my oracle database to another PC. What is the easiest way to do it? Are there any GUI tools to do it?
287
Follow the steps in Opening a Database to make sure the database on the NEW host has been opened. On the NEW host, perform a database restore from the backup, as described in Restoring Backed Up Data. On any other networked computers, connect to the database on the NEW host by following the steps in Opening a Database.
Using the main menu, select Tools->Database Export. An Export wizard will open. At the top of the screen, enter a directory and file name.
APC's answer is the way to go for a logical transfer. If you're asking because you just want a one-time transfer to another PC then:
create the same directory structure for the database files on the second PC
copy the database files (tablespace files, control files, redo logs) to the second PC (with the database shut down on PC #1!)
128
The easiest way to transfer database structures (tables, packages, etc) together with data (or indeed without it) is to use the Oracle import/export utlities. As you're using Oracle 11g you should employ Data Pump for this. (On 9i or earlier it would be the old EXP and IMP utlities).
Use Export (expdp) to make the dump file from your source PC. Transfer it to your target PC and use Import (impdp) to load it.
At this point I would link to the documentation but the Oracle online docs are currently offline. So here's a link to the Oracle Wiki page instead: find out more.
42
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
