sitg
asked on
DB migration from 8i to 10g
hi,
I have oracle 8i DB with 100 GB size. Now want to transfer it to oracle 10g.
It would take very long time if Export/Import is used.
is it possible to clone the DB from oracle 8i to oracle 10g?
How we can perform this task, Please advice.
Thanks,
I have oracle 8i DB with 100 GB size. Now want to transfer it to oracle 10g.
It would take very long time if Export/Import is used.
is it possible to clone the DB from oracle 8i to oracle 10g?
How we can perform this task, Please advice.
Thanks,
if you do export/import remember to use the corect versions of each.
Export with 8i exp
Import with 10g imp
Export with 8i exp
Import with 10g imp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
or upgrade your 8i db.
You can't "clone" and "upgrade" in a single step.
You could clone to another 8i copy first and then upgrade the clone.
that wouldn't save you any time but would allow you to run both versions in parallel to check if everything is ok.