Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

migrated from stackoverflow.com Aug 11 '11 at 11:21

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

1  
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

2 Answers 2

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

 
discard

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.