Question

oracle物化视图问题

因为软件厂商给的用户没有在远程数据库创建物化视图日志的权限,所以创建的物化视图在刷新时采用先truncate掉,再全刷新方式。这与填充普通表的结构不是没多大区别了吗? insert into client_table as select * from remote_table@remote_dblink(client_table 为与remote_table表结构一致的表) 在remote_table数据量比较大的情况下,哪种方式效率更高一些呢?

Answer 1

用这个吧 ALTER MATERIALIZED VIEW 看这篇文档 START WITH Clause Specify START WITH date to indicate a date for the first automatic refresh time. NEXT Clause Specify NEXT to indicate a date expression for calculating the interval between automatic refreshes. Both the START WITH and NEXT values must evaluate to a time in the future. If you omit the START WITH value, Oracle Database determines the first automatic refresh time by evaluating the NEXT expression with respect to the creation time of the materialized view. If you specify a START WITH value but omit the NEXT value, Oracle Database refreshes the materialized view only once. If you omit both the START WITH and NEXT values, or if you omit the alter_mv_refresh entirely, Oracle Database does not automatically refresh the materialized view. 蓝屏