Re: Error after trigger
From: Frank <fbortel_at_nescape.net>
Date: Thu, 11 Dec 2003 22:03:37 +0100
Message-ID: <bralil$jo4$1_at_news1.tilbu1.nb.home.nl>
>> Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote in message
>> news:<3o1ftv4o1qt73cjkuhk8e4jffj910f9jtt_at_4ax.com>...
>>
>>> On 10 Dec 2003 08:19:33 -0800, Ralph.Backes_at_web.de (Ralph) wrote:
>>>
>>> You would better set up Oracle replication instead of reinventing the
>>> wheel.
>>
>>
>> Hi !
>>
>> OK, I didn't know this possibility but it didn't seem to be usefull
>> for this problem, cause it shall be an online update not every hour. I
>> think it's better to work when there is something to do, than set up
>> routines that check allways around... Perhaps I'm just to simple
>> minded for Oracle ;)
>>
>>
>>> Other than that: look up ora-2041 in the error messages manual on
>>> http://tahiti.oracle.com and work from there.
>>
>>
>>
>> Thanx for the link, seems to be a very good point for investigations.
>> I found a hint, but not the clue 'till now...
>>
>> Bye
>> Ralph
Date: Thu, 11 Dec 2003 22:03:37 +0100
Message-ID: <bralil$jo4$1_at_news1.tilbu1.nb.home.nl>
Daniel Morgan wrote:
> Ralph wrote: >
>> Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote in message
>> news:<3o1ftv4o1qt73cjkuhk8e4jffj910f9jtt_at_4ax.com>...
>>
>>> On 10 Dec 2003 08:19:33 -0800, Ralph.Backes_at_web.de (Ralph) wrote:
>>>
>>> You would better set up Oracle replication instead of reinventing the
>>> wheel.
>>
>>
>> Hi !
>>
>> OK, I didn't know this possibility but it didn't seem to be usefull
>> for this problem, cause it shall be an online update not every hour. I
>> think it's better to work when there is something to do, than set up
>> routines that check allways around... Perhaps I'm just to simple
>> minded for Oracle ;)
>>
>>
>>> Other than that: look up ora-2041 in the error messages manual on
>>> http://tahiti.oracle.com and work from there.
>>
>>
>>
>> Thanx for the link, seems to be a very good point for investigations.
>> I found a hint, but not the clue 'till now...
>>
>> Bye
>> Ralph
> > > I'd suggest you follow Sybrand's lead if you wish to be successful. And > there is no such thing as real-time. Everything has a latency. How much > can your system tolerate? 10ms? 1sec? 1min? It doesn't have to be hourly. >
For near real-time replication lookup "replication" and "on commit" on the link Sybrand provided
-- Regards, Frank van BortelReceived on Thu Dec 11 2003 - 22:03:37 CET