Update record Snapshot [message #322688] |
Sun, 25 May 2008 23:14  |
sirfkashif
Messages: 70 Registered: September 2007 Location: Rawalpindi
|
Member |
|
|
Dear all,
I am connected to apps schema and used snapshots to select data from remote database, it worked fine but now i need to update data using those snapshot which is not allowed.
Any help will be appreciated
Regards,
Kashif Ali
|
|
|
|
|
Re: Update record Snapshot [message #322748 is a reply to message #322700] |
Mon, 26 May 2008 02:31  |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Alternatively, would it be possible to do something like this: in order to use a snapshot (materialized view), you have to have access to the remote database. It is done via database link.
Now, if snapshot is a "simple" one (such as SELECT this_column, that_column FROM a_single_table@database_link WHERE some_condition), you could update "a_single_table@database_link" instead. Snapshot will then reflect changes you've made (when? It depends on refreshing frequency - if ON COMMIT, you'd see it "now").
|
|
|