Re: Synchronizing 2 tables in same database -how ?

From: Christian Svensson <chse30_at_hotmail.com>
Date: 21 Nov 2003 02:30:24 -0800
Message-ID: <ccc2a7eb.0311210230.2ffde5ce@posting.google.com>

Thanks Dias,

I will give it a try next week, but do you know if there are a way to exclude this new table from the backup, we use RMAN. Because there is no need for that table to be backed up.

Thanks.

/Christian

ydias_at_hotmail.com (dias) wrote in message news:<55a68b47.0311201247.4bb63d5c_at_posting.google.com>...
> 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
>
Received on Fri Nov 21 2003 - 04:30:24 CST