Re: 2 Phase Commit including an Oracle 6 node

mj_at_dde.dk (Martin Jensen) writes:
|> At the IOUG two years ago in San Francisco, I heard that it was possible
|> to have an Oracle version 6 node coorporation in a group of Oracle7 nodes,
|> to commit distributed transactions.
|> As Oracle 6 does not support the 2PC protocol, the strategy was to let the
|> Oracle 6 node be the transaction master, as all the Oracle7 could do
|> a prepare_to_commit, then Oracle 6 could do a commit, and then all the other
|> nodes could do the accept_commit.

Unfortunately, there may have been some misinformation out there back then. Oracle V6 can be updated via a database link from an Oracle7 node, but it must be done within a single site update.

In other words:
begin transaction

   update remote V6 site via dblink
commit

is legal, but  

begin transacation

   update remote V6 via dblink
   update local V7 or other remote site
   (in any order)

will result in an error.

Roderick Manalac
Oracle Corporation Received on Mon Oct 03 1994 - 21:58:26 CET