Re: Replication groups partially removed

Alan,

Was quite involved with a replication system a while back. The simplest, safest approach is to do as you say and run catrepr.sql. I do recall getting some groups stuck on occasion, and I think a delete from DBA_REPGROUP's underlying tables might get you there. But as I'm sure you know deleting from dictionary tables tends to leave your database unsupported as far as Oracle are concerned...

This is also a good reason for using scripted replication setup - though I think OEM templates achieve the same thing. There're only about five DBMS_REPCAT calls to get to grips with as far as I remember.

Cheers,

John Thomas

In message <F001.004AB672.20020805093907_at_fatcity.com>, alan.aschenbrenner_at_ihs.com writes
>
>Hi,
>
> Any replication gurus out there? Currently I'm in the process of
>setting up another replication system between several databases. I set it
>up correctly the first time around, but then noticed that the domain was
>set to US.ORACLE.COM. (Quite annoying! As if anyone would actually want
>that for a default domain...what ever happened to WORLD, or none at
>all?!?!). So, I proceeded to remove the sites from the master group and
>fixed the domain name.
> When I tried to setup the replication again, it wouldn't allow me to
>add one of the databases back into the group. I received a unique
>constraint violation, claiming that the group already existed in that
>database (even though I "removed" it just a few minutes earlier). It
>appears that the DBA Studio GUI didn't properly remove all the group data
>from the replication tables. I have since recreated the master group under
>a different name, but I would still like to clear out all the junk from the
>old group.
> Has anyone else run into this? Does anyone have a list of tables that
>can be deleted from? Or perhaps a package that I have overlooked? I
>suppose I could just remove the replication from the database (catrepr.sql)
>and then re-install it (catrep.sql), but what's the fun in that? And there
>is still the outside chance that it won't work correctly also...
>
>Thanks,
>
>Alan Aschenbrenner
>Oracle DBA
>Information Handling Services
>alan.aschenbrenner_at_ihs.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 
John Thomas
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Thomas
  INET: john_at_toronto.demon.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).