Home » SQL & PL/SQL » SQL & PL/SQL » Update record Snapshot
Update record Snapshot [message #322688] Sun, 25 May 2008 23:14 Go to next message
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 #322690 is a reply to message #322688] Sun, 25 May 2008 23:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above
Re: Update record Snapshot [message #322700 is a reply to message #322688] Mon, 26 May 2008 00:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Use updatable snapshots (materialized view) which is much complex than read-only ones.
You have to read the documentation in order to achiev this.

Regards
Michel
Re: Update record Snapshot [message #322748 is a reply to message #322700] Mon, 26 May 2008 02:31 Go to previous message
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").
Previous Topic: Get workweek in pl/sql
Next Topic: Update trigger
Goto Forum:
  


Current Time: Sat Feb 15 12:08:43 CST 2025