Home » Server Options » Replication » Snapshots without MLOG$ tables in remote database
Snapshots without MLOG$ tables in remote database [message #75349] Wed, 26 March 2003 18:48 Go to next message
Messages: 7
Registered: February 2001
Junior Member

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 Go to previous message
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.
Previous Topic: Is Table Primary Key Essential for Oracle Replication
Next Topic: very urgent - want to download pachset 9
Goto Forum:

Current Time: Fri Sep 17 12:28:14 CDT 2021