Problem solve Get help with specific problems with your technologies, process and projects.

ORA-2064 error

I am getting the error, "ORA-2064: distributed operation not supported across a database link." The confusing part is that everything works to a certain point, inserting across the link, and then I get this error. Any ideas what could be causing this?

You get the ORA-2064 error when you attempt to do one of the following:

  1. An array execute of a remote update with a subquery that references a database link.
  2. An update of a long column with bind variable and an update of a second column with a subquery that references both a database link and a bind variable.
  3. a commit in a coordinated session issued from a remote procedural call with OUT parameters.

Fix which ever one applies, and you will no longer see the ORA-2064 error. Without seeing the actual SQL statement, it is difficult to tell which operation is tripping you up.

Dig Deeper on Oracle database backup and recovery