up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
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
feedback

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

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

2 Answers

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.

link|improve this answer
feedback
up vote 0 down vote

With impdp/expdp you can do it

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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