syncronize two tables

From: <beersa.beersa_at_gmail.com>
Date: 19 Aug 2006 01:12:47 -0700
Message-ID: <1155975167.708024.141530@m79g2000cwm.googlegroups.com>

My appln has one master table, say tb_1, with filed-1 to field-5. Another table, say tb_2, is dependent on tb_1. tb_2 has f3 fields, are fields-6,field-7 and field-8. Pl/sql procodeure is updating the tb_2 from tb_1. The fileds on both tables are mapping like:

tb_1            tb_2
~~~            ~~~~
field-1 ->   field-6
field-2 }
field-3 }--> field-7

field-4 }
field-5 }

The pl/sql procedure select the field-1 from tb_1 and insert into tb_2. And concatnate the field-2 to field-5 in tb_1 and insert into tb_2. Both tables tb_1 and tb_2 has views, say v_1 and v_2 resply. The user has only access to views not the tables. The problem is both views are not synchronize. Why it is happen?What is the remedy?

Zillion thanks. Received on Sat Aug 19 2006 - 03:12:47 CDT