问Oracle:使用预构建表时不刷新实体化视图

EN

CREATE TABLE empt 
  ( ename VARCHAR2(20),
    empno INTEGER PRIMARY KEY);

CREATE MATERIALIZED VIEW LOG ON empt
   WITH SEQUENCE , rowid (empno)
 INCLUDING NEW VALUES;

CREATE MATERIALIZED VIEW empt_MV
    REFRESH FAST ON COMMIT 
    WITH ROWID
     AS
     SELECT count(*) numberofemps
     FROM empt ;

INSERT INTO empt VALUES ('A',1);
COMMIT;

SELECT * FROM empt_MV;

NUMBEROFEMPS
------------
           1

drop materialized view empt_mv;
drop materialized view log on empt;
drop table empt;

CREATE TABLE empt 
  ( ename VARCHAR2(20),
    empno INTEGER PRIMARY KEY);

CREATE MATERIALIZED VIEW LOG ON empt
   WITH SEQUENCE , rowid (empno)
 INCLUDING NEW VALUES;

CREATE TABLE empt_MV (
  numberofemps NUMBER);

CREATE MATERIALIZED VIEW empt_MV
    ON PREBUILT TABLE
    REFRESH FAST ON COMMIT 
    WITH ROWID
     AS
     SELECT count(*) numberofemps
     FROM empt ;

INSERT INTO empt VALUES ('A',1);
COMMIT;

SELECT * FROM empt_MV;