The file is about 380 mb and the model is a little complex, but not much has changed in the last months yet I can't seem to refresh at all in the past weeks.
It's an integer field and 'id' is the primary key on the table. I had the same issue with an openquery that updates i Series. The fix is to include the key columns in the select.
So in your case it would be something like this: Turns out there's nothing wrong with the query.
A master table can have only one materialized view log defined on it.
Oracle Database can use this materialized view log to perform fast refreshes for all fast-refreshable materialized views based on the master table.
Delivered='YES' FROM OPENQUERY(LINK_DB, 'SELECT * FROM XXXXR. O1') OQ JOIN OPENQUERY(LINK_DB, 'SELECT * FROM XXXXR.