Can I use imp/exp tools to migrate database from Oracle 9 to Oracle 10
Posted
by Karol Kolenda
on Stack Overflow
See other posts from Stack Overflow
or by Karol Kolenda
Published on 2010-03-21T15:29:35Z
Indexed on
2010/03/21
15:31 UTC
Read the original article
Hit count: 595
Oracle
I'm subcontractor and my client wants to upgrade Oracle database from 9 to 10. Other vendor is going to perform the upgrade process, and I was asked to create whatever backup I need before the upgrade, and then recreate the environment in Oracle 10. All my data is stored in a separate database in a single schema. No fancy relations, scripts or anything like this (actual app supports different dbs: Oracle, SQL Server, Postgres so we want to avoid any DB-specific code).
I was hoping to use imp/exp but I'm not sure if imp/exp are backward compatible (exp from O9 and imp to O10)?
If there is a better/recommended way of dealing with similar situation, I'll be grateful for any advice.
© Stack Overflow or respective owner