Solved

Moving Oracle XE

Posted on 2009-04-01
2
516 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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

Suggested Solutions

Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

821 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