contactkarthi
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You have to use the exp tools from oracle 8i and the imp tool of oracle 10g for the task.
ASKER
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
ASKER
the scenario here is we have a new server for 10g. the content from the 8i has to be moved to 10g box.