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

Filed under:

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

Related posts about Oracle