Link to home
Start Free TrialLog in
Avatar of contactkarthi
contactkarthiFlag for United States of America

asked on

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.
SOLUTION
Avatar of chedgey
chedgey
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of contactkarthi

ASKER

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.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You have to use the exp tools from oracle 8i and the imp tool of oracle 10g for the task.

so by using "imp" and "exp" executables.. you mean i can skip the version(9.x) and migrate the contents from 8i to 10g..
yep