Re: oracle9i lite synchronisation

tiger wrote:
> Not quit sure what you mean by that Frank !
>
> When the users presses 'synchronise' in the application the
> application must dowload his tasks! How will the mobile server know
> what to synchronise ?
>
> thanks
> Nico
>
> On Thu, 03 Apr 2003 22:10:49 +0200, Frank <fvanbortel_at_netscape.net>
> wrote:
>
>

>>tiger wrote:
>>
>>>Is it possible to let the user on a mobile device (e.g. laptop) decide
>>>what rows he wants to synchonize ??
>>>
>>>
>>>I have a table  like this    
>>>(employee_nr number(5), task varchar2(100))
>>>
>>>the employee may only download the rows for himself not for others ?
>>>
>>>
>>>thanks
>>>Nico
>>
>>where employee_nr = :this employee's number? Works for materialized
>>views, which can be replicated using snapshot replication.
>>
>>-- 
>>Regards, Frank van Bortel
>>

Because the server "knows" about each and every change. It will apply the rule (where employee number = ...) as defined in the materialized view on the client, and download only thos changes.

That is what snapshot logs are for. On the master tables.

-- 
Regards, Frank van Bortel