Re: Use MV to convert 9i to 10g

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Mon, 24 Nov 2008 07:21:22 +0200
Message-id: <492A39D2.5020205@inter.net.il>


No, I can not.
Streams do not copy the existing data to the new database, only the changes that occur after you activate streams. The manual says that you have to procreate the target database using exp/imp or rman.

Adar Yechiel
Rechovot, Israel

Mark Brinsmead wrote:
> 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
> <mailto:adar666_at_inter.net.il>> wrote:
>
> Hi all
>
> Can I use materialized views to copy data from existing 9.2.0.6
> <http://9.2.0.6> database to 10.2.0.3 <http://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
Received on Sun Nov 23 2008 - 23:21:22 CST

Original text of this message