As of 10g, Oracle Spatial utilizes temporary tables, which means that it can no longer be used in conjunction with distributed transactions. There is, in other words, a breaking change as of 10g, which causes all applications that depend on both spatial data and distributed transactions to no longer work.

The problem occurs in cases where changes of spatial data are made before an exception is raised within a distributed transaction. When the exception is raised, the distributed transaction is aborted but since Oracle Spatial depends on temporary tables the spatial changes are not rolled back adequately and are left hanging.

Any subsequent changes of related spatial data will cause an ORA-14450 to be raised.

The error message is:

ORA-14450: attempt to access a transactional temp table already in use


escuelle said...

The same problem has been experienced by others and is described here and here.

escuelle said...

An update on the issue is found here.