物化视图刷新的时候如何不产生归档日志?
fast好像不产生归档日志,但是我的物化视图是这样的:
create materialized view M_ALL_OBJ
refresh
fast
start with SYSDATE
next SYSDATE+1/48
with primary key
as
select m.id,1 NO,m.name,1 SETTIME,1 LATESTTIME from table1 m
union all
select m.id,1 NO,m.name,1 SETTIME,1 LATESTTIME from table2 m
union all
select m.id,1 NO,m.name,1 SETTIME,1 LATESTTIME from table3 m
union all
select m.id,1 NO,m.name,1 SETTIME,1 LATESTTIME from table4 m
union all
select m.id,1 NO,m.name,1 SETTIME,1 LATESTTIME from table5 m
报错:ora-12015:不能从复杂查询中创建一个快速刷新的实体化视图我怎么处理才能不产生大量的归档日志?
谢谢
fast好像不产生归档日志,但是我的物化视图是这样的:
create materialized view M_ALL_OBJ
refresh
fast
start with SYSDATE
next SYSDATE+1/48
with primary key
as
select m.id,1 NO,m.name,1 SETTIME,1 LATESTTIME from table1 m
union all
select m.id,1 NO,m.name,1 SETTIME,1 LATESTTIME from table2 m
union all
select m.id,1 NO,m.name,1 SETTIME,1 LATESTTIME from table3 m
union all
select m.id,1 NO,m.name,1 SETTIME,1 LATESTTIME from table4 m
union all
select m.id,1 NO,m.name,1 SETTIME,1 LATESTTIME from table5 m
报错:ora-12015:不能从复杂查询中创建一个快速刷新的实体化视图我怎么处理才能不产生大量的归档日志?
谢谢
ALTER MATERIALIZED VIEW <schema.materialized_view>
<LOGGING | NOLOGGING>;