Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Multi snapshots

Re: Multi snapshots

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sun, 20 Feb 2005 10:28:48 +0100
Message-ID: <42185820$0$14699$626a14ce@news.free.fr>

"zeb" <spam_at_nowhere.com> a écrit dans le message de news:421856c6$0$21719$626a14ce_at_news.free.fr...
| Hi,
|
| For read only snapshot,
| is it possible to have several snapshots
| for one master table ?
|
| What I saw, is that the MLOG$_
| is truncated after a refresh.
|
| How can I have a master table replicated to several
| remote tables ?
|
| Thanks in advance
|
| Oracle 9.2.0.5
| AIX 5.1
|
|

Yes, you can.
Log is not truncate, rows are deleted until the oldest row that was not replicated in any remote site.

Regards
Michel Cadot Received on Sun Feb 20 2005 - 03:28:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US