Refresh fast as demand
As
Select 1 as mark, t1. A, t1. B, t1. C
The from t1
Union all
Select the as 2 mark, t2. A, t2. B, t2. C
The from t2
;
A similar to create fast refresh materialized views statement,
How to create a materialized view log,
Online found a lot of articles about materialized views to limit, and tried to use, after has been submitted to the 12052 error,
When you create the LOG, if use with the rowid, then in the creation of materialized views, after the select plus the rowid fields, to 00904, the rowid field there is no
Realize the demand of the materialized view log how to set up?
CodePudding user response:
https://blog.csdn.net/cckevincyh/article/details/88982217CodePudding user response:
Problem solved,Used when creating the LOG with the rowid o new values
When you create materialized views, select followed by rowid
Before I submitted to the 00904 error because I don't have to rename the rowid that a column name, behind the rowid plus as arowid
Fast refresh was successful
Very strange errors,
As for links, those articles I've seen, yet to find a reason to come here to ask, I also have a problem not themselves can't even baidu isn't it,