Re: Convert database from AIX to Windows
Date: Wed, 18 Jan 2012 20:04:08 +0000
Message-ID: <4F1725B8.8090106_at_dunbar-it.co.uk>
Evening,
> There is a proposal to consolidate all hardware platform and we are looking
> at converting the database from IBM/AIX to Windows. What would be the best
> method to do this? Datapump or Transportable tablespace? The database is
> about 120G with2 large tablespaces each about 50-60G. Any gotchas with this
> conversion?
Not having used datapump yet, I'd be thinking about TTs myself. I used
them recently to copy over a few terabytes from HPUX PA-RISC to Linux
x86-86. It worked, however:
The exporting database has to be at 10.2.0.4 (I think) or above to get the use of cross platform TTs.
Also, the exporting database must be Enterprise Edition. A Standard Edition can only import TTs.
Other than that, and mine was from 9.2.0.6 SE to 11.2.0.2 SE, it's quite simple.
9206SE->9206EE->10204 first, then did the TT stuff. A quick RMAN to convert the datafiles to Linux and the imported them. Just worked.
Much much quicker than exp/imp!
Got a few more to do on my current project when they get the storage sorted out.
have fun.
Cheers,
Norm.
-- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 18 2012 - 14:04:08 CST