Q
Manage Learn to apply best practices and optimize your operations.

Upgrading database from 8i to 9i

What do I need to upgrade Oracle from 8i to 9i? I am pretty new in Oracle; I know about SQL but nothing about Oracle. Please help me out.

What do I need to upgrade Oracle from 8i to 9i? How can I upgrade the database? I am pretty new in Oracle; I know about SQL but nothing about Oracle. Please help me out. I have to install Oracle9i on my computer and then upgrade the database.

There are a variety of ways to upgrade an 8i database to 9i, including using the DBUA (Database Upgrade Assistant), performing the upgrade manually via scripts, using the export/import utilities and, finally, the CTAS (create table as select) method. Each method is described in detail in the Oracle9i Release 2 (9.2) Database Migration Guide found here.

Prior to performing an upgrade, you will first want to install Oracle9i in a separate ORACLE_HOME from where Oracle8i is currently installed. After this is completed, you can then migrate your database to Oracle9i with whatever method best suits your situation.

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.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close