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 -> Problems with refresh

Problems with refresh

From: Łukasz Rzepa <rzepa_at_comarch.pl>
Date: Thu, 08 Oct 1998 12:05:19 GMT
Message-ID: <361CA9F1.A1B37186@comarch.pl>


Welcome.

We have distributed database (Oracle 7) with one master site and several snaphot sites. We had to suspend one of the snapshot sites. The problem is that master site still generate logs for suspended site. Our log table (mlog$_<table_name>) is growing which couse that refresh other sites is very slow (mlog$_.. table contains 2000000 records). Does anyone knows how to turn off snapshot site ? I can't delete all snaphots because this base is suspend only temporary.

Maybe somebody could send me complete descripton of refresh mechanism. I want detailed description with role of each system table (in schemas SYS and SYSTEM). --


  Łukasz Rzepa
  programista

 ComArch SA
 ul.Czarnowiejska 66 tel: +48 12 4234570 fax: +48 12 6339229  30-054 Kraków

     mailto:rzepa_at_ComArch.PL
                          http://www.comarch.pl


___________________________________________________________________
Received on Thu Oct 08 1998 - 07:05:19 CDT

Original text of this message

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