ORA-00904 when inserting over a db-link

ORA-00904 when combining function-based index and db-link

There seems to be a bug related to expression based (function based) indexes when the optimizer creates a plan for inserts over a database link. The symptom is ORA-00904: … : invalid identifier.

Continue reading “ORA-00904 when inserting over a db-link”