Re: replication question

If you have to to this on a regular base and you have a SQL*Net connection between the databases, you can work with snapshots. If you can use fast refreshable snapshots (refer to the oracle docu what criteria has to be fullfilled for a fast refreshable snapshot) you can refresh frequently.

This works for read-only and updateable snapshots as-well.

Thomas

Nicholas Mudie wrote:
>
> Hi,
>
> What's the best way to replicate SOME tables from one DB to another? Thanks.
>
> Nicholas Mudie
> Chello
 

-- 


 
_______________________________________________________________________
Siemens Switzerland Ltd, Softwarehaus, ES41
Thomas Jegen, Software Engineer
Albisriederstrasse 245, CH-8047 Zürich
Phone +41 (0)1 495 3438, Fax  +41 (0)1 406 5340 
mailto:thomas.jegen_at_siemens.ch, Internet: http://www.siemens.ch/