在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; 一个基础的小问题,求解 请求一条pl/sql 有没有类似oracle的帮助文档的《concepts Guide》之类的纸质的书卖,中英文皆可。 导入数据的时候表空间的问题 ORACLE 9i中查找被锁表的问题 入门问题 二个问题, 欢迎指导 怎么清空整个数据库中所有数据表中的数据,急!!! 关于触发器的 存储过程报pls00103:Encountered the symbol "b_cur " when exception one of the foll 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;