Re: URGENT: Need help for homegrown snapshot mechanism.

On 17 Jun 98 18:48:53 GMT, mnawani_at_table.jps.net () wrote:

>Hi all,
>
> I need some help in implementing a round-about way of doing
> snapshots by using part of the Oracle process of
> creating snapshot logs and then using my own procedures
> to create a delta of the changes and the delta of the MLOG$ table
> which will then be applied on the target site (which happens to be
> in another country) through a process that will delete all the
> records from the table and then append the records from the delta.

This way you'll have the modified records only...

>
> The delta tables will be sent through an export.
>
> Can anyone please tell me if this looks workable?

Given that you've been through the understanding of Oracle Replication, I suggest you to use the feature described as 'offline instantiation' or whatever.

I understand, however, that the poor performance of Oracle refreshes can lead you to implementing your homegrown solution ;-) [Oracle 7.3, no flames thanks]

>
> Please help.
>
>Thanks in advance
>Mahesh Nawani
>

--
Mauro.

(My return address is intentionally invalid; ROT13 is required.
As someone already told this audience, my responses are not to be
considered official technical support or advice.)