Lock Table in Remote Database does not work
Hi all
I should lock a table over a database link in a remote database. If the origin is Oracle 10.1 and the remote Oracle 11.2 SE1, it works perfectly. In the other direction (Oracle 11.2/11.1 Standard Edition One -> Oracle 10.1), I get the following error:
Does anyone have an idea?
I should lock a table over a database link in a remote database. If the origin is Oracle 10.1 and the remote Oracle 11.2 SE1, it works perfectly. In the other direction (Oracle 11.2/11.1 Standard Edition One -> Oracle 10.1), I get the following error:
lock table tableowner.tablename@dblinkname in share row exclusive mode;DML commands like INSERT, UPDATE or DELETE are possible without problem. And because there's no difference in the syntax, the error message is not really helpful to me...
*
ERROR in line 1:
ORA-00933: SQL command not properly ended
ORA-02063: preceding line from tableowner.tablename@dblinkname
Does anyone have an idea?
0