Home > Ask the Oracle Database / Applications Experts > Questions & Answers > Upgrading from 9.2.9.7 to 10g Express Edition
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

Upgrading from 9.2.9.7 to 10g Express Edition

Maria Anderson EXPERT RESPONSE FROM: Maria Anderson

Pose a Question
Other Oracle Categories
Meet all Oracle Experts
Become an Expert for this site


Oracle tips, scripts, and expert advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 09 July 2006
Can we upgrade from Oracle 9.2.0.7 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 9.2.0.7 (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 9.2.0.7 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.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Oracle database installation, upgrades and patches
How to use the Oracle Database Upgrade Assistant (DBUA)
Oracle delivers database fixes in Critical Patch Update
How to get the most out of Toad for Oracle 10
Coca-Cola Bottling swaps out Oracle for DB2
Oracle renews push into embedded open source software market
Oracle releases new database, says 11g upgrade will cut costs
Comparing servers for Oracle database 11g upgrades
Choosing the right server hardware is all about choosing the right software
The best of the Oracle 11g-ready servers
Can Sun shine running Oracle 11g?

How to upgrade to Oracle 10g
Steps to migrate from Oracle 8.0.6 to Oracle 10g R2
Easiest way to migrate from Oracle 7i to Oracle 10g
How to migrate Oracle 10g to RAC cluster on Linux
Migrate 6 TB of data from Oracle 8.1.7 to Oracle 10gR2
Impact of Oracle 8i to Oracle 10g migration on scripts
Lessons Learned: Upgrading to Oracle 10g
Database too large for exp/imp migration
How to apply patch to Oracle 10g on Linux?
Migrating 9i database on Windows to 10g on SLES
Impact on memory for upgrade to Oracle 10g

Upgrading from Oracle 9i or later
How to migrate Oracle 10g to RAC cluster on Linux
Lessons Learned: Upgrading to Oracle 10g
How to apply patch to Oracle 10g on Linux?
Migrating 9i database on Windows to 10g on SLES
Impact on memory for upgrade to Oracle 10g
Faster way to migrate to 10g on Linux
Upgrading to Solaris 10 and Oracle 10g
Copying zipped files to 10g
Migrate to 9.2.0.7 first or directly to 10g?
Upgrading to 10g on Unix Server

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
10g  (SearchOracle.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Oracle White Papers: Fusion Middleware
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts