What is the easiest way to transfer Oracle database from one PC to another?

oracle oracle11g data-transfer
Nubkadiya picture Nubkadiya · Jun 24, 2010 · Viewed 16.3k times · Source

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?

Answer

dpbradley picture dpbradley · Jun 24, 2010

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:

  • install the same version of Oracle on the second PC

  • 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!)

Related questions

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More
How do I do top 1 in Oracle?

How do I do the following? select top 1 Fname from MyTbl In Oracle 11g?

Read More
ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client

I'm trying to connect to a schema on 11g (v11.2.0.1.0) from a PC with 9i (v9.2.0.1) client. It seems to connect fine to some schemas, but not this one - it comes back with a ORA-01017 Invalid Username/Password error …

Read More