Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
>
> 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).Received on Fri Jun 13 2003 - 10:34:02 CDT