Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to restore a backup of an Oracle database which runs on UNIX to an Oracle 10g Express Edition ( instance on Windows?

share|improve this question

migrated from Aug 11 '11 at 11:21

This question came from our site for professional and enthusiast programmers.

What sort of backup do you have? RMAN? Export? Copies of datafiles? – APC Aug 9 '11 at 15:28
What are you trying to do, restore a backup for test or just move some data for testing purposes? – oluies Aug 9 '11 at 16:49
@oluies - restore a backup to compare some data – Ray Dookie Aug 9 '11 at 22:08
@APC - The files are all .dbf files – Ray Dookie Aug 9 '11 at 22:10
up vote 3 down vote accepted

The DBF files cannot simply be copied over.

A proper database backup includes the SYSTEM (and SYSAUX) tablespaces which will have some features that the express edition won't support (a whole bunch of stuff requiring java for a start) so I'd be very surprised if it is successful.

An EXPDP / IMPDP should work (providing you are not using features incompatible with Express Edition). Also look at transportable tablespaces which may or may not work depending on your unix platform.

share|improve this answer

With impdp/expdp you can do it

share|improve this answer
Go on then, any details about how to do it with these tools? – jscott Jul 15 '12 at 0:29

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.