ORA-00933 when trying to lock a remote table
edited Nov 22, 2010 4:52AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
Hi all
If I try to lock a table in a remote db, I get the error message ORA-00933 (Local DB Oracle 11.1 SE1 or 11.2 SE1 -> Remote DB 1Oracle 0.1). Other commands like updates on the same remote table works fine and in the other direction (Oracle 10 -> 11) the same statement works perfectly. Has something changed between 10 and 11 (I found no clue in the documentation) or do I have to activate something?
The statement and the error message look like:
LOCK TABLE tableowner.tablename@dblink101 IN SHARE ROW EXCLUSIVE MODE;
*
Error in row 1:
ORA-00933: SQL command not properly ended
ORA-02063: preceding line from dblink101
If I try to lock a table in a remote db, I get the error message ORA-00933 (Local DB Oracle 11.1 SE1 or 11.2 SE1 -> Remote DB 1Oracle 0.1). Other commands like updates on the same remote table works fine and in the other direction (Oracle 10 -> 11) the same statement works perfectly. Has something changed between 10 and 11 (I found no clue in the documentation) or do I have to activate something?
The statement and the error message look like:
LOCK TABLE tableowner.tablename@dblink101 IN SHARE ROW EXCLUSIVE MODE;
*
Error in row 1:
ORA-00933: SQL command not properly ended
ORA-02063: preceding line from dblink101
0