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”
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”