–1.删除原有的物化视图:biz_bus
DROP MATERIALIZED VIEW biz_bus;
–2.创建新的物化视图:
create materialized view BIZ_BUS
refresh complete on demand
start with sysdate next sysdate+numtodsinterval(15,’second’)
as
select
“bus_id” as bus_id,
“bus_no” as bus_no,
“line_no” as line_no,
“station_id” as station_id,
“runtime” as runtime,
“line_direct” as line_direct,
“samp_num” as samp_num,
“location_x” as location_x,
“location_y” as location_y,
“bus_v” as bus_v from dbo.t_bus@busdb;
Oracle物化视图
最新推荐文章于 2020-01-16 10:23:22 发布