Solved

Moving Oracle XE

Posted on 2009-04-01
2
504 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
Comment Utility
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
Comment Utility
Thank you, creating a dmp file and then importing it worked perfectly!
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Read about achieving the basic levels of HRIS security in the workplace.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

772 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