Solved

Moving Oracle XE

Posted on 2009-04-01
2
509 Views
Last Modified: 2013-12-18
I have a new computer with the same version of Oracle XE as my old computer.   I need to move my development environment including my Oracle XE databases to this new computer.  

What is the best way to move the Oracle XE databases to the new computer?
0
Comment
Question by:mrotstein
2 Comments
 
LVL 1

Accepted Solution

by:
fox9106 earned 50 total points
ID: 24044627
I suggest you two options:

1) Generate a dump file
a) Use Export Datapump with the Full=Y option to generate a dumpfile.
see http://www.oracle.com/technology/products/database/utilities/pdf/datapump11g2009_quickstart.pdf
b) Copy the dumpfile to the new computer
c) them import the dump file using impdp

2) If you are familiar with oracle architecture you can copy the datafiles, redologfiles, password file and the control files to the same diretory at the new machine.

0
 

Author Closing Comment

by:mrotstein
ID: 31565428
Thank you, creating a dmp file and then importing it worked perfectly!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to free up undo space? 3 39
How to join on ID, with prefix? 15 58
ServiceCenter IR Query Expressions 1 12
T-SQL Default value in Select? 5 22
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now