在8.1.5里有USER_MVIEW_REFRESH_TIMES吗 在8.1.5里有USER_MVIEW_REFRESH_TIMES吗?从这里可以得到物化视图的刷新时间。可是在8.1.5里怎么没有这个表啊?那么应该如何获得呢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 物化视图在8i里似乎是叫snapshot的,后来才改名materialized view ==========================================创建物化试图(快照)==========================================刷新类型:FAST REFRESH Create Materialized View Fast Refresh CREATE MATERIALIZED VIEW <schema.name>PCTFREE <integer>PCTUSED <integer>TABLESPACE <tablespace_name>BUILD IMMEDIATEREFRESH <FAST | FORCE> ON <COMMIT | DEMAND> AS (<SQL statement>); -- create refresh log firstCREATE MATERIALIZED VIEW mv_simpleTABLESPACE data_smlBUILD IMMEDIATEREFRESH FAST ON COMMIT ASSELECT *FROM servers;SELECT name, table_name, updatable, refresh_method,refresh_modeFROM user_snapshots;set long 10000SELECT name, queryFROM user_snapshots;SELECT name, last_refreshFROM user_mview_refresh_times;刷新类型:Complete RefreshCREATE MATERIALIZED VIEW <schema.name>PCTFREE <integer>PCTUSED <integer>TABLESPACE <tablespace_name>REFRESH <COMPLETE | FORCE>START WITH <date>NEXT <date_calculation>[FOR UPDATE]AS (<SQL statement>); CREATE MATERIALIZED VIEW mv_complexTABLESPACE data_smlREFRESH COMPLETESTART WITH SYSDATENEXT SYSDATE + 1AS SELECT s.srvr_id, i.installstatus, COUNT(*)FROM servers s, serv_inst iWHERE s.srvr_id = i.srvr_idGROUP BY s.srvr_id, i.installstatus;SELECT name, table_name, updatable, refresh_methodFROM user_snapshots;SELECT name, table_name, refresh_methodFROM user_snapshots;col next format a30SELECT name, type, next, start_with, refresh_groupFROM user_snapshots;col query format a50SELECT name, query, statusFROM user_snapshots; 计算机名改了,导致oracle 10g em 登录问题? oracle修改表空间大小--急 求助 筛选重复数据的菜鸟问题 菜鸟求解一个简单问题 问一个关于Varchar和Nvarchar的问题 求一个合格率的SQL在线等 一个新手的简单问题,在线等! oracle存储过程实现 表内建立子分区 这个存储过程错在那里? oracle中字段的别名中可以使用函数吗? 不同版本之间的dblink,可以吗?
创建物化试图(快照)
==========================================
刷新类型:FAST REFRESH
Create Materialized View
Fast Refresh CREATE MATERIALIZED VIEW <schema.name>
PCTFREE <integer>
PCTUSED <integer>
TABLESPACE <tablespace_name>
BUILD IMMEDIATE
REFRESH <FAST | FORCE> ON <COMMIT | DEMAND>
AS (<SQL statement>);
-- create refresh log firstCREATE MATERIALIZED VIEW mv_simple
TABLESPACE data_sml
BUILD IMMEDIATE
REFRESH FAST ON COMMIT AS
SELECT *
FROM servers;SELECT name, table_name, updatable, refresh_method,
refresh_mode
FROM user_snapshots;set long 10000SELECT name, query
FROM user_snapshots;SELECT name, last_refresh
FROM user_mview_refresh_times;
刷新类型:Complete Refresh
CREATE MATERIALIZED VIEW <schema.name>
PCTFREE <integer>
PCTUSED <integer>
TABLESPACE <tablespace_name>
REFRESH <COMPLETE | FORCE>
START WITH <date>
NEXT <date_calculation>
[FOR UPDATE]
AS (<SQL statement>);
CREATE MATERIALIZED VIEW mv_complex
TABLESPACE data_sml
REFRESH COMPLETE
START WITH SYSDATE
NEXT SYSDATE + 1
AS SELECT s.srvr_id, i.installstatus, COUNT(*)
FROM servers s, serv_inst i
WHERE s.srvr_id = i.srvr_id
GROUP BY s.srvr_id, i.installstatus;SELECT name, table_name, updatable, refresh_method
FROM user_snapshots;SELECT name, table_name,
refresh_method
FROM user_snapshots;col next format a30SELECT name, type, next, start_with, refresh_group
FROM user_snapshots;col query format a50SELECT name, query, status
FROM user_snapshots;