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”

Speeding up large data-transfers over a db-link

Lately I’ve been working a lot with large bulk-loads of data between Oracle databases. The loading is done over db-links and we needed to speed up some of the loads since parallel DML is not supported in distributed transactions.

Continue reading “Speeding up large data-transfers over a db-link”