Re: Use MV to convert 9i to 10g
- From: "Yaping Chen" <hangzhoumaster@xxxxxxxxx>
- To: adar666@xxxxxxxxxxxx
- Date: Sun, 23 Nov 2008 19:41:01 +0800
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@xxxxxxxxxxxx>:
>
> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Regards,
Yaping Chen
http://yaping123.wordpress.com
Other related posts:
