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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Replication

Re: Replication

From: Arup Nanda <orarup_at_hotmail.com>
Date: Fri, 21 Feb 2003 07:30:05 -0800
Message-ID: <F001.00554578.20030221073005@fatcity.com>


MessageIs the MV set up for FAST REFRESH or COMPLETE?

If FAST REFRESH, check to see if the tablespace of MV Log table, named MLOG$_<tablename> where <tablename> is the first 20 characters of the table on which the log is based, has enough space for the mlog$ to grow.

If complete refresh, do it manually from command line

exec DBMS_SNAPSHOT.REFRESH('<tablename>,'CF')

and see what error message is given. A few things come to my mind

(1) not enough temp space for the sorting to occur for he MV
(2) not enough rollback segment space.

Either way, you will see the exact error it fails on.

HTH. Arup Nanda

  I was asked of a problem in a friend's site about replication.

  The problem.

  They implemented replication using Materialized Views with an refresh update of ON DEMAND and some immediate. It works for some days and suddenly some MV stop replicating.

  He has checked metalink, but can't open a TAR.

  Is there any recommendation that you can give him to check.

  Ramon E. Estevez
  com.banilejas_at_codetel.net.do
  809-565-3121

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: orarup_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Feb 21 2003 - 09:30:05 CST

Original text of this message

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