Re: ER between two databases in the same instance
- From: "Madison Pruet" <mpruet@xxxxxxxxxxx>
- Date: Fri, 9 Sep 2005 12:00:29 -0500
"Dirk Moolman" <DirkM@xxxxxxxxxxxxxx> wrote in message
news:1126282330.055c5803673ac8591640e3ad28f74182@xxxxxxxxxxx
>
> Some people might disagree with me, but it would be nice to have, even
> if just for marketing purposes. Imagine someone asking this question
> when comparing databases. Can your database do this ? It just makes
> the database so much more flexible.
>
> Question is, can Oracle do this ? Need to compete with the others ...
>
Well --- maybe. The real question would be is "Does this functionality
increase sales and/or address customer needs. And if it does, then what is
the need that it addresses.". I mean Oracle might implement a function
called callGeorgeBushWhenTransactionAborts(). Well - I don't think that
we'd implement such a functionality just because Oracle did. ;-)
I can see one need for replicating to the same instance because I could have
additional triggers on the target table which could fire. But instead of
implementing replication to myself to support that functionality, it'd
probably make more sense to simply implement post-commit triggers.
That's why I'm trying to understand the reason for this request. Thanks.
M.P.
>
> -----Original Message-----
> From: owner-informix-list@xxxxxxxx [mailto:owner-informix-list@xxxxxxxx]
> On Behalf Of Madison Pruet
> Sent: 08 September 2005 08:27 PM
> To: informix-list@xxxxxxxx
> Subject: Re: ER between two databases in the same instance
>
> Question for the group as a whole... How important is this
> functionality?
>
> "cristizaharioiu" <cristizaharioiu@xxxxxxxxx> wrote in message
> news:1125990751.160483.46740@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > Hello,
> >
> > Can I define a replicate for a table between two databases in the same
> > instance (the same group) ?
> >
> > Here is the replicate :
> >
> > cdr define repl -C ignore --scope=transaction --immed --ats --ris
> > r_tabela_test "P bd_test_1@g_scot79:informix.tabela_test" "select *
> > from tabela_test " "R bd_test_2@g_scot79:informix.tabela_test"
> > "select * from tabela_test"
> >
> > I tried to define it and I got next error : command failed --
> duplicate
> > server or replicate (53)
> > participant bd_sco79@g_scot79:informix.tabela_test 'select * from
> > tabela_test '.
> >
> > The replicate is not duplicate only server could be.
> >
> > The medium is IDS 10 & Suse Sles 9.
> sending to informix-list
.
- References:
- RE: ER between two databases in the same instance
- From: Dirk Moolman
- RE: ER between two databases in the same instance
- Prev by Date: ER replication failures from 9.30.FC5 to 10.00.FC3
- Next by Date: Re: Cperf problem creating C function for Perform screen
- Previous by thread: RE: ER between two databases in the same instance
- Next by thread: Client host or user is not trusted by the server
- Index(es):
Relevant Pages
|
