Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Multi snapshots
"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