Re: Replication

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

• Original Message ----- From: Ramon E. Estevez To: Multiple recipients of list ORACLE-L Sent: Friday, February 21, 2003 8:19 AM Subject: Replication

  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).