Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Select for Update fails
amerar_at_iwc.net (Arthur) wrote:
>ORA-02015: cannot select FOR UPDATE from remote table
If the Oracle 8i docs can be believed:
Cause: An attempt was made to SELECT... FOR UPDATE from a table in a remote database.
Action: It is not currently possible to SELECT... FOR UPDATE from a table in a remote database. Instead, log in or connect directly to the remote database before entering a SELECT... FOR UPDATE on its tables.