Re: Use MV to convert 9i to 10g
Date: Sun, 23 Nov 2008 19:41:01 +0800
You can create tables on 10203, then create MV on these tables using
You may refresh incremental for large tables, complete refresh for small tables.
And you should check whether all data type can be refreshed through MV.
Other objects, such as trigger, procedure, you can extract the defination and create them manually.
2008/11/23, Yechiel Adar <adar666_at_inter.net.il>:
> Hi all
> Can I use materialized views to copy data from existing 22.214.171.124 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
-- Regards, Yaping Chen http://yaping123.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Sun Nov 23 2008 - 05:41:01 CST