CREATE MATERIALIZED VIEW CUX2_MATERIALIZED_MES_V
REFRESH FORCE ON DEMAND
START WITH TO_DATE('26-07-2011', 'DD-MM-YYYY') NEXT TRUNC(SYSDATE+1)
AS
SELECT "MACHINENAME",
"MACHINETYPE",
"DETAILMACHINETYPE",
"DESCRIPTION",
"FACTORYNAME",
"AREANAME",
"SUPERMACHINENAME",
"MACHINEGROUPNAME",
"VENDOR",
"MODEL",
"SERIALNO",
"WORKAREA",
"RESOURCEGROUP",
"RESOURCETYPE",
"RESOURCEMODE",
"CHUCKCOUNT",
"STEPPERMODEL"
FROM machinespec@mes;
Oracle 物化视图
最新推荐文章于 2024-07-17 10:28:57 发布