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?
migrated from stackoverflow.com Aug 11 '11 at 11:21
This question came from our site for professional and enthusiast programmers.
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.