[Materialized Views over DB links]HA Problem with ORA-02019
From: Jia Lu <roka100_at_gmail.com>
Date: Wed, 24 Mar 2010 02:29:38 -0700 (PDT)
Message-ID: <993c419f-fedf-4d06-92c0-c3c259274c56_at_k6g2000prg.googlegroups.com>
Hi all
I created 2 multi master DBs and using materialize views to synchronize them.
The relation is Main - Sub, and when I insert/commit to either one , another site's table will be updated.
Date: Wed, 24 Mar 2010 02:29:38 -0700 (PDT)
Message-ID: <993c419f-fedf-4d06-92c0-c3c259274c56_at_k6g2000prg.googlegroups.com>
Hi all
I created 2 multi master DBs and using materialize views to synchronize them.
The relation is Main - Sub, and when I insert/commit to either one , another site's table will be updated.
My problem is when DB link failed, I cannot insert data into the normal DB it said ORA-02019.
That will be a high availability problem when one DB is down.
Is there a feature can let me to update to the table when another site
is down?
And can it be synchronized after the db link recovered ?
Thank you.
Best
Lau Lu.
Received on Wed Mar 24 2010 - 04:29:38 CDT