[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.

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