Steps for Migrating from Oracle 8i to Oracle 10g

I need to know what are the steps that i need to take care when migrating my application from Oracle 8i to Oracle 10g. it is a java based application with Stored procedures, triggers and like 25 tables in oracle 8i.
LVL 17
Who is Participating?
TolomirConnect With a Mentor AdministratorCommented:
If you want to migrate just a few users you can go with exp/imp

see for details:

chedgeyConnect With a Mentor Commented:
Well, the obvious answer is RTFM!
With your oracle 10g database you received the documentation set (electronic I assume) that includes a book called "Oracle Database Upgrade Guide" that has all the information you need. It includes chapters on  the differences between behaviour from 8i to 10g as well as lists of all things that need to be taken into account both in the database and your applications. If you do not have these then the full documentation set is readily available for viewing or download from

Apart from the obvious source above there is loads of information on this subject available on the web so I would suggest a Google search using keywords "Migrate Oracle 8i to 10g" and you will find lots of case studies and additional information.

Good luck.



contactkarthiAuthor Commented:
i did a small research on that and did go through the Upgrade guide. read that upgrade cannot skip major releases.

the scenario here is we have a new server for 10g. the content  from the 8i has to be moved to 10g box.
The new generation of project management tools

With’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

TolomirConnect With a Mentor AdministratorCommented:
Especially here

Look for the "imp" and "exp" executables in your $ORACLE_HOME/bin directory. One can run them interactively, using command line parameters, or using parameter files. Look at the imp/exp parameters before starting. These parameters can be listed by executing the following commands: "exp help=yes" or "imp help=yes".

The following examples demonstrate how the imp/exp utilities can be used:

exp scott/tiger file=emp.dmp log=emp.log tables=emp rows=yes indexes=no
exp scott/tiger file=emp.dmp tables=(emp,dept)

imp scott/tiger file=emp.dmp full=yes
imp scott/tiger file=emp.dmp fromuser=scott touser=scott tables=dept
You have to use the exp tools from oracle 8i and the imp tool of oracle 10g for the task.

contactkarthiAuthor Commented:
so by using "imp" and "exp" executables.. you mean i can skip the version(9.x) and migrate the contents from 8i to 10g..
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.