[Materialized Views over DB links]HA Problem with ORA-02019
Date: Wed, 24 Mar 2010 02:29:38 -0700 (PDT)
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
And can it be synchronized after the db link recovered ?
Lau Lu. Received on Wed Mar 24 2010 - 04:29:38 CDT