Re: Use MV to convert 9i to 10g

Hi Yechiel,

You can create tables on 10203, then create MV on these tables using prebuild table.
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 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
>
>
>

-- 
Regards,
Yaping Chen

http://yaping123.wordpress.com

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