Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: syncronize two tables

Re: syncronize two tables

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 19 Aug 2006 10:22:30 +0200
Message-ID: <3eide2diegh8hvi98chgq0stk4r1h0ar0g@4ax.com>


On 19 Aug 2006 01:12:47 -0700, beersa.beersa_at_gmail.com wrote:

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

You assume there is a generic problem with views in version x. Because of your assumption you withheld both version x and the view definition.
You also don't tell whether it is a real view or a materialized view or whether you verified the consistency of tb_1 and tb_2. Do we still need to explain to you, doing so you can't expect any responses?

--
Sybrand Bakker, Senior Oracle DBA
Received on Sat Aug 19 2006 - 03:22:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US