Manage Learn to apply best practices and optimize your operations.

Upgrading from to 10g Express Edition

Can we upgrade from Oracle to Oracle 10g Express Edition?

Can we upgrade from Oracle to Oracle 10g Express Edition?
If you read the information on Oracle's Technology Network Web site about Oracle Database 10g Express Edition, it says "Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that's free to develop, deploy, and distribute; fast to download; and simple to administer. Oracle Database XE is a great starter database …"

If you are currently running Oracle (either Standard or Enterprise) in a production environment, you might want to look at upgrading it to Oracle 10g Database. I have not found any material that indicates that you can upgrade from release to Express Edition. Also, remember that XE "will store up to 4GB of user data, use up to 1GB of memory, and use one CPU on the host machine" so this will limit what you can do with it.

Having said that, you might be able to export the schemas in your Oracle9i database and import them into Oracle 10g Database Express Edition. Also, with your download you can register for the Oracle 10g Express discussion form on OTN.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.