Re: move database from sparc to linux
From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Mon, 21 Jun 2010 17:24:46 +1000
Message-ID: <hvn3vf$nim$1_at_news.eternal-september.org>
tb wrote,on my timestamp of 21/06/2010 2:51 AM:
Date: Mon, 21 Jun 2010 17:24:46 +1000
Message-ID: <hvn3vf$nim$1_at_news.eternal-september.org>
tb wrote,on my timestamp of 21/06/2010 2:51 AM:
> i have to move a 10.2.0.3 database from solaris sparc to red hat
> linux. I see 4 possibilities
>
> 1. exp/imp
> 2. expdp/impdp
> 3. Transportable Tablespaces
> 4. Oracle Streams
>
> The first approach was expdp and was not succesful, because there are
> 400000 database objects in a 100GByte database. When i'm using expdp
> there, is no progress after one hour. I think exp will take between 30
> and 35 hours. Any idea is welcome.
That must be indeed a very slooooow Solaris sparc system! I regularly export 100GB with expdp in AIX in much less than 2 hours. Admittedly: a lot less than 400k db objects. Around 75K. Received on Mon Jun 21 2010 - 02:24:46 CDT