Use MV to convert 9i to 10g

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Sun, 23 Nov 2008 08:47:04 +0200
Message-id: <4928FC68.8050105@inter.net.il>

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 Received on Sun Nov 23 2008 - 00:47:04 CST

This message: [ Message body ]
Next message: Mark W. Farnham: "RE: Setting db_32k_cache_size breaks 11.1.0.7"
Previous message: Amir Gheibi: "Transfer Data to another tablespace with different name"
Next in thread: Yaping Chen: "Re: Use MV to convert 9i to 10g"
Reply: Yaping Chen: "Re: Use MV to convert 9i to 10g"
Reply: Mark Brinsmead: "Re: Use MV to convert 9i to 10g"
Reply: Mercadante, Thomas F (LABOR): "RE: Use MV to convert 9i to 10g"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message