How can I upgrade Standard to Enterprise Edition of Oracle 8.1.6?
If you are staying on Oracle 8.1.6, then you'll just need to install Oracle EE in the same ORACLE_HOME as Oracle SE. For good measure, I'd rerun CATALOG and CATPROC as SYS after I fire up the database.
If you are going to go to a different version, then install Oracle EE in a new ORACLE_HOME. Then follow the upgrade procedures outlined in the Oracle Migration Guide for your new version.
Another resource is to look at the webcast that I did for SearchOracle.com on Upgrading to 9i. While you may not be upgrading to 9i at this time, many of the points in the webcast are still valid for your version. You can find a copy of the webcast here.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.