Re: Rebuilding MLOG tables

You are very welcome.

I agree, Oracle must have had a wave of those PHBs in their development side each with their own trumpet to blow and each left his or her legacy with a new package. Otherwise why they cose to have so many of these packages to do a few simple, very correlated things beats me. Even though I have been doing replication for seven years now, I have a hard time remembering which package has what.

As to the last part of your post (the question actually), you always had to create a master group and associate a refresh group to that. The decision to include which tables in a master group depends on the relationship among the tables and whether they must be refreshed in one shot to maintain logical integerity. But I almost always found it better to have a group per a table.

HTH. Arup Nanda
www.proligence.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 13, 2003 10:09 AM

>
> Didn't know about this one. Thanky thanky.
>
> So now we have dbms_refresh, dbms_repcat, and dbms_mview (more?) each with
> its own bucket of procedures. It gives one the impression that there is
> some significant developer turnover at Oracle with each new batch of
> programmers imposing their own ideas about things ought to done.
>
> I guess, for this to work, a master group (as opposed to a refresh group
on
> the client) must be created, eh?
>
> > -----Original Message-----
> >
> > The safest and recommended way is to queisce the replication
> > master group by
> >
> > dbms_repcat.suspend_master_activity('GroupName');
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephen Lee
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).