move 9i r2 database on host 1 to 10g r1 on another host

From: sundar mahadevan <>
Date: Sat, 8 Aug 2009 15:16:59 -0400
Message-ID: <>

Hi All,

Many Thanks to Robert Freeman, Mark Bobak, Dick Goulet for helping me out on my previous question on incomplete recovery. Unfortunately I did not get a chance to resolve the issue as another DBA is currently working on it. So I cannot give any updates on it currently.

I'm running a test environment. The test database is small. I would like to move/migrate 9i r2 database on host 1 to 10g r1 on host 2. 9i r2 and 10g r1 are the software versions on host 1 and 2 respectively. I would like to receive suggestions on how to do this. My ideas are as follows: Create a new database on 10g r1 with the same name as test database on 9i r2 and export the tablespaces from host 1(9i r2) and import it in newly created database using transport_tablespace on host 2(10g r1). To my knowledge an export from 9i r2 will be compatible in 10g r1. Any help is greatly appreciated. Can the same step be followed for large databases? If not what would be procedure for large databases? Thanks in advance.

Received on Sat Aug 08 2009 - 14:16:59 CDT

Original text of this message