Snapshots without MLOG$ tables in remote database [message #75349] |
Wed, 26 March 2003 18:48 |
Rajan
Messages: 7 Registered: February 2001
|
Junior Member |
|
|
Hi,
Can anyone let me know if snapshots in one database exist without the corresponding snaphot log (MLOG$) tables in the remote database, If so, what should be the configuration of this setup. Thanks for any ideas.
- Rajan
|
|
|
Re: Snapshots without MLOG$ tables in remote database [message #75370 is a reply to message #75349] |
Sat, 07 June 2003 02:15 |
Paul van Velzen
Messages: 6 Registered: June 2003
|
Junior Member |
|
|
You can create snapshots without snapshot logs on the master tables. You will have to perform a complete refresh to replicate with means that you move all the rows (at least the rows included in the where-clause of the snapshot) from the master table in the remote database to the snapshot site. When your master tables at your remote database grow to large proportions, this is not something you should want.
|
|
|