Re: Synchronizing 2 tables in same database -how ?

Hi,

The refresh fast option will not be a good choice here. This will create a snapshot log that will be very large and il could take a long time to refresh the MV.

CTAS with nologging, as Jonhatan said, will be faster. But this have to be tested ...

Dias

doron_almog_at_msn.com (Doron) wrote in message news:<995517bc.0311200752.36d57c95_at_posting.google.com>...
> hi,
>
> did you think about creating a materialized view of the table with the
> fast refresh option? it seems to me that it will fit your needs.
>
> regards,
> Doron
Received on Thu Nov 20 2003 - 14:47:36 CST