Re: distributed database option

I used to have the same problem. When you tried to update two tables on different instance without a commit in the middle, oracle will think that they are one transaction and gotta have distributed option installed in order to update/insert/delete more than one instance in a "single" transaction. Frankly speaking, I still have not find a way to get around with this. if you can allow to update the tables between the instances once every few days. I will suggest you to create a snapshot between those tables.

Winnie

Allan Nelson wrote in message <35D6F204.43F9D207_at_austin360.com>...
>soumitrabose_at_hotmail.com wrote:
>
>> I need a help/advice.
>> I am installing two instances of Oracle 8.0.4 on a sequent box.
>> I have triggers in a few tables in both the instances. These triggers
>> insert,update and delete in the two tables of the two instances. That
means,
>> when there is an insert in one table of one instance the insert will
trigger
>> another instance in a similar table in the other instance.
>> when I try to run the insert,update and delete I get an error message
stating
>> that (error code 2088) that distributed option is not available and for
v7 one
>> has to buy it as a separate patch. But the versions of my databases are
8.0.4.
>> What should I do to overcome this?
>> I am in a mission critical application and I have come to a screaching
halt.
>> I would appreciate any urgent help and advise.
>> Thanks,
>
>You can do this through the creation of a database link. You can do this
without
>having the distributed database option installed, I think.
>
>Allan
>
Received on Sun Aug 16 1998 - 21:51:45 CDT