1

I have a need to restore a dump (which is less than 1GB). Can I restore a dump that was made in either enterprise or standard to express? I'm asking because I know from experience with SQL that this is impossible. I've been looking and I can't see to locate if Oracle has the same limitations.

3
  • Did you try? What was the outcome?
    – mustaccio
    Aug 13, 2018 at 18:54
  • @mustaccio No, sorry. My comment is a bit vague but I did mention I have a need, implying that I don't have the DB yet. This is a proposal in which I do not have a testing environment to test this situation out (meaning i can't produce an enterprise or standard dump). And if I could have found the documentation I wouldn't have asked. Sorry!
    – JL1
    Aug 13, 2018 at 20:19
  • I can find this docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/… but I cannot find any explicit documentation that says you cannot import a dump into express.
    – JL1
    Aug 13, 2018 at 20:24

1 Answer 1

4

As far as I can tell, yes - you can import a DMP file whose origin is Standard or Enterprise edition into an Express edition database.

However, there are certain restrictions. One of them seems to be OK - size of user data (you have less than 1 GB, while 11g XE accepts up to 11 GB).

If tables are partitioned in the source database, they won't be imported as XE doesn't support partitioning. (Though, if you pre-create such a table and import only data, that should also be OK.)

The same goes for other features that aren't supported by XE (such as internal Java virtual machine, materialized view query rewrite) - they won't be imported.

If tablespace names are different in the source and XE database, don't forget to include the REMAP_TABLESPACES parameter.

I suggest you give it a try; XE is a nice tool to play with. Review the log file - it'll tell you which objects weren't imported and why. Good thing is that - even if something fails to import - it won't stop other objects from importing. Then you'll know whether the final result suits your needs or not.

2
  • Congratulations friend, seems you are good at administration, too. Aug 26, 2018 at 17:08
  • 1
    Hello, @Barbaros! Thank you, but - as far as administration is concerned, I enjoy watching Oracle administering itself :)
    – Littlefoot
    Aug 26, 2018 at 17:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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