Re: Use MV to convert 9i to 10g
Date: Mon, 24 Nov 2008 09:19:49 +0800
Message-ID: <ef9b14410811231719o905e786o8d140f1d179cc9b9@mail.gmail.com>
sorry, i do not have streetwise experience on it.
but i think you can do using Logical stand as solution, using log miner
technical, but you need pay attention the copied tables need follow oracle
restrict.
please give us a hint while you get solution from oracle support :)
On Sun, Nov 23, 2008 at 7:41 PM, Yaping Chen <hangzhoumaster_at_gmail.com>wrote:
> 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
-- ("'-''-/").___..--''"'-._ '7_ 7 ) '_. ( ).'-.__.') (_Y_.) ._ ) '._ '. ''-..-' _.'--'_..-_/ /--'_.' ,' (il),-'' (li),' ((!.-' Best regards, Yours sincerely House baojiejie_at_gmail.com -- http://www.freelists.org/webpage/oracle-lReceived on Sun Nov 23 2008 - 19:19:49 CST