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?

asked 08 Mar '17, 05:00

Oliver's gravatar image

Oliver
11112
accept rate: 0%

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.

(08 Mar '17, 07:01) Volker Barth

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

(08 Mar '17, 07:28) Breck Carter
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • 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:

×38
×31
×7

question asked: 08 Mar '17, 05:00

question was seen: 1,874 times

last updated: 08 Mar '17, 07:28