Re: Use MV to convert 9i to 10g

Providing you meet the requirements, you *should* be able to do this with Streams.

On Sat, Nov 22, 2008 at 11:47 PM, Yechiel Adar <adar666_at_inter.net.il> wrote:

> Hi all
>
> Can I use materialized views to copy data from existing 9.2.0.6 database
> to 10.2.0.3?
> From windows 32 bit to Linux 64 bit?
>
> I have a 3 TB database that I need to move.
>
> What happened during the first refresh that copy all the data, is the
> originating table still available for updates during this time?
>
> I will research the new and open an SR but I want your opinion where this
> is practical.
>
> --
> Adar Yechiel
> Rechovot, Israel
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Cheers,
-- Mark Brinsmead
  Senior DBA,
  The Pythian Group
  http://www.pythian.com/blogs

--
http://www.freelists.org/webpage/oracle-l