Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.astraweb.com!news-small.astraweb.com!news-big.astraweb.com!207.217.77.102.MISMATCH!elnk-pas-nf2!elnk-pas-nf1!newsfeed.earthlink.net!cyclone.socal.rr.com!news-west.rr.com!cyclone.nyroc.rr.com!cyclone-out.nyroc.rr.com!twister.nyroc.rr.com.POSTED!53ab2750!not-for-mail
From: Paul Murphy <pmurphy@scsinet.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc
Subject: Re: Just need a small hint re: mirroring tables
References: <EYqMa.28406$iZ3.16890@twister.nyroc.rr.com> <a1d154f4.0307012343.388c677@posting.google.com> <uFAMa.30886$iZ3.21205@twister.nyroc.rr.com> <3F02FC52.ABD7D271@exxesolutions.com> <2WDMa.31337$iZ3.30149@twister.nyroc.rr.com> <D3EMa.436$aD6.131@nwrddc03.gnilink.net> <NaEMa.31400$iZ3.7650@twister.nyroc.rr.com> <4a66gv4jm29dv27564ulvefucehg0ivjhi@4ax.com> <b6ab6d71.0307030716.fc7bf4f@posting.google.com> <wsYMa.10895$C43.5190@nwrddc04.gnilink.net> <rI0Na.43631$8B.24870@twister.nyroc.rr.com>
In-Reply-To: <rI0Na.43631$8B.24870@twister.nyroc.rr.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 23
Message-ID: <BlnOa.24776$ma.1418@twister.nyroc.rr.com>
Date: Mon, 07 Jul 2003 23:27:29 GMT
NNTP-Posting-Host: 24.169.88.212
X-Complaints-To: abuse@rr.com
X-Trace: twister.nyroc.rr.com 1057620449 24.169.88.212 (Mon, 07 Jul 2003 19:27:29 EDT)
NNTP-Posting-Date: Mon, 07 Jul 2003 19:27:29 EDT
Organization: Road Runner
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:129116

Paul Murphy wrote:
>  >Anurag Varma wrote:
> 
>> Your code is a DBA's worst nightmare. I will never recommend or accept 
>> this
>> as a
>> solution!

Great news. Thanks to the help I received on this group, I was able to 
convince everyone that we should just use a single set of tables and use 
private synonyms for the other software to access them. No triggers, no 
duplicate tables, just a couple of synonyms.

So, if any of you run into a Banner / Maximo integration problem and the 
vendors try to get you to mirror tables in the same database with 
triggers...tell them NO.

Thanks again. I look forward to the day when I've got enough experience 
to help the future newbies that visit c.d.o.m.

Paul Murphy