Re: Export from 9.2.0.6 and import to 11gR2
- From: Alisher Yuldashev <yuldashev@xxxxxxxxxxx>
- To: avadhanimys@xxxxxxxxx
- Date: Wed, 25 Aug 2010 15:51:38 -0400
No, you don't need to upgrade.
The basic compatibility rules are:
- Export the data with the Export utility of the lowest database version
involved.
- Import the data with the Import utility of the target database.
- An export dump file created with the (old-style) export utility 'exp'
(e.g. Oracle9i), cannot be imported with the new Oracle10g import
datapump utility 'impdp' (and vice versa).
For 32bit to 64bit conversion check "How to Use Export and Import when
Transferring Data Across Platforms or Across 32-bit and 64-bit Servers
[ID 277650.1]".
Thanks,
Alisher Yuldashev
Senior Oracle DBA
www.pythian.com
On 8/25/2010 3:43 PM, Andrew Kerber wrote:
I dont think an upgrade is required to do an exp/imp.
On Wed, Aug 25, 2010 at 2:36 PM, Diego Cutrone
<diegocutrone@xxxxxxxxxxxx <mailto:diegocutrone@xxxxxxxxxxxx>> wrote:
Hi Avadhani,
You need to follow ML note 730365.1
I believe you will need to upgrade to 9.2.0.8 first
Regards,
Diego
Other related posts:
