CREATE MATERIALIZED VIEW MV_SYS_OFFICE
REFRESH FORCE
ON DEMAND
START WITH SYSDATE NEXT TRUNC(SYSDATE,'MI')+1/24/60 
AS
SELECT "SYS_OFFICE"."ID" "ID","SYS_OFFICE"."PARENT_ID" "PARENT_ID","SYS_OFFICE"."PARENT_IDS" "PARENT_IDS","SYS_OFFICE"."NAME" "NAME","SYS_OFFICE"."SORT" "SORT","SYS_OFFICE"."AREA_ID" "AREA_ID","SYS_OFFICE"."CODE" "CODE","SYS_OFFICE"."TYPE" "TYPE","SYS_OFFICE"."GRADE" "GRADE","SYS_OFFICE"."ADDRESS" "ADDRESS","SYS_OFFICE"."ZIP_CODE" "ZIP_CODE","SYS_OFFICE"."MASTER" "MASTER","SYS_OFFICE"."PHONE" "PHONE","SYS_OFFICE"."FAX" "FAX","SYS_OFFICE"."EMAIL" "EMAIL","SYS_OFFICE"."USEABLE" "USEABLE","SYS_OFFICE"."PRIMARY_PERSON" "PRIMARY_PERSON","SYS_OFFICE"."DEPUTY_PERSON" "DEPUTY_PERSON","SYS_OFFICE"."CREATE_BY" "CREATE_BY","SYS_OFFICE"."CREATE_DATE" "CREATE_DATE","SYS_OFFICE"."UPDATE_BY" "UPDATE_BY","SYS_OFFICE"."UPDATE_DATE" "UPDATE_DATE","SYS_OFFICE"."REMARKS" "REMARKS","SYS_OFFICE"."DEL_FLAG" "DEL_FLAG" FROM "UAMS"."SYS_OFFICE" "SYS_OFFICE";