|
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? |
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 08 Mar '17, 05:00
question was seen: 1,732 times
last updated: 08 Mar '17, 07:28
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."