建立物化视图的语句是什么？
显示刷新成功，在哪里显示的？使用 dbms_mview.refresh 手动刷新的？

是的，手动dbms刷新的，显示执行成功，奇怪的是物化视图日志也不记录数据的变化，count(*)一直是0条数据

SQL> select count(*) from jymasb.MLOG$_T_API_INVENTORY_LOG;

COUNT(*)

     0
复制

Create Materialized View Log On T_API_INVENTORY_LOG With Rowid;

SQL> exec dbms_mview.refresh(‘T_DT_INVENTORY_LOG_MV’,‘f’);

PL/SQL procedure successfully completed.

CREATE MATERIALIZED VIEW “T_DT_INVENTORY_MV” (“ID”, “LAST_UPDATE_DATE”, “ABLESALEQUANTITY”)
SEGMENT CREATION IMMEDIATE
ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 163840 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE “BIODSD”
BUILD IMMEDIATE
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE “BIODSD”
REFRESH FAST ON DEMAND
WITH ROWID USING DEFAULT LOCAL ROLLBACK SEGMENT
USING ENFORCED CONSTRAINTS DISABLE ON QUERY COMPUTATION DISABLE QUERY REWRITE
AS SELECT
“T_DT_INVENTORY”.“ID” “ID”
,“T_DT_INVENTORY”.“LAST_UPDATE_DATE” “LAST_UPDATE_DATE”
,“T_DT_INVENTORY”.“ABLESALEQUANTITY” “ABLESALEQUANTITY”
FROM “JYMASB”.“T_API_INVENTORY”@BI_JXCB

日志没建错库？？ 看你用了dblink

没建错啊，不然其他库都没这个表。