Hi, we have created a proxy table 'orders' in our main database. We created a view 'v_orders' in our branch database for reading the data. This works fine. We can also do Updates on 'orders' from main and branch. But doing an update on 'v_orders' only works in the main database. So how to update view which is pointing on a proxy table from the branch database? |
Hm, I still do not understand how many database objects you refer to. For example, when saying "created a proxy table 'orders' in our main database" - what exactly does that mean? Is the table "orders" located in the main database or is it declared there as proxy table and the real table resides in another database?
It would be helpful if you could list the according (simplified) CREATE [EXISTING] TABLE / CREATE TABLE / CREATE VIEW commands (without column details) and in which database you have executed them..., and then tell which update statement work and which don't - again with telling in what database those are run.
If the view is a straightforward subset of columns, you can also define a subset in the CREATE EXISTING TABLE statement: "You may choose to include only a subset of the actual remote column list in your CREATE EXISTING statement."