就这么小段: INSERT INTO A_RCVED_PL_FLOW(RCVED_PL_ID,RCVED_AMT_ID,ITEM_CODE,PL_AMT,ORG_NO) SELECT RCVED_PL_ID,RCVED_AMT_ID,ITEM_CODE,PL_AMT,ORG_NO FROM A_RCVED_PL_FLOW@DB_EPM A WHERE EXISTS (SELECT 1 FROM A_RCVED_FLOW B WHERE A.RCVED_AMT_ID=B.RCVED_AMT_ID AND B.ORG_NO LIKE V_SUB_DEPT) AND A.ORG_NO LIKE V_SUB_DEPT; COMMIT;记录数大概2400万
你用物化视图的方式来刷新吧,在源数据库上建立物化视图日志create materialized view mv_test BUILD IMMEDIATE refresh force on commit as select * from emp; create materialized view log on emp; 这样会实时刷新,同样,你可以设置成非实时刷新,可以根据物化视图日志中的更新类型(insert, update, delete)来决定你自己的刷新策略
INSERT INTO A_RCVED_PL_FLOW(RCVED_PL_ID,RCVED_AMT_ID,ITEM_CODE,PL_AMT,ORG_NO)
SELECT RCVED_PL_ID,RCVED_AMT_ID,ITEM_CODE,PL_AMT,ORG_NO
FROM A_RCVED_PL_FLOW@DB_EPM A
WHERE EXISTS (SELECT 1 FROM A_RCVED_FLOW B WHERE A.RCVED_AMT_ID=B.RCVED_AMT_ID AND B.ORG_NO LIKE V_SUB_DEPT)
AND A.ORG_NO LIKE V_SUB_DEPT;
COMMIT;记录数大概2400万
BUILD IMMEDIATE
refresh force on commit
as select * from emp;
create materialized view log on emp;
这样会实时刷新,同样,你可以设置成非实时刷新,可以根据物化视图日志中的更新类型(insert, update, delete)来决定你自己的刷新策略