Insufficient key column information for updating and refreshing

Rated 4.88/5 based on 745 customer reviews

Instead, the data is owned by some specific provider, and the CCE must submit update requests in the form of SQL commands. You are currently viewing the BOOK: Beginning Access VBA section of the Wrox Programmer to Programmer discussions.

Without a materialized view log, Oracle Database must reexecute the materialized view query to refresh the materialized view. Usually, a fast refresh takes less time than a complete refresh.

I have a project that is linked to SQL Server 2000, in which I have constructed a view of two linked tables.

They have the same PK in a one-to-one relationship. When I perform an identical update from SQL Server 2000, the change is successful.

A materialized view log is located in the master database in the same schema as the master table.

A master table can have only one materialized view log defined on it.

Leave a Reply