Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am aware that Oracle Ent Ed (EE) has more functionality than Oracle Express Ed (XE). But I would like to do a FULL export from EE to XE. Is this even possible? The only solution I can assume will work would be to export/import tablespaces or schemas.

A comment was made that this question was not precise so let me clarify (hopefully):

EE has features that XE does not have. It follows that EE may have schemas that XE does not have or use. When the import is done, will the import fail in XE because those 'extra non-XE' schemas are not recognized due to the absence of the feature in XE? Or will XE just 'not fail, not care'?

NOTE: I was hoping to do a FULL export which is why I am concerned about the schemas being different between EE and XE.

HTH

share|improve this question
    
I don't think this question is sufficiently precise to get a clear answer. Yes, you could do export from EE and import into XE. In lots of cases this would meet your requirement for being a FULL export. But of course if you're using EE features you won't have access to them in XE. –  mdahlman Jul 2 at 15:02
    
Edited the question to be more precise. Thx mdahlman –  tale852150 Jul 2 at 15:21
    
You can do a full export and always import just the schemas you want from the dump. Personally, I'd just export the schemas I was interested in, assuming it's not hundreds. –  Colin 't Hart Jul 2 at 15:59
    
Thanks, Colin. Based on your suggestion, that's probably the route I'll take. –  tale852150 Jul 2 at 21:37

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.