Oracle-L: Replication groups partially removed

From: <alan.aschenbrenner_at_ihs.com>
Date: Mon, 05 Aug 2002 09:39:07 -0800
Message-ID: <F001.004AB67E.20020805093907@fatcity.com>

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

Author:
INET: alan.aschenbrenner_at_ihs.com

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). Received on Mon Aug 05 2002 - 12:39:07 CDT