CREATE MATERIALIZED VIEW MV
REFRESH FORCE ON DEMAND

start with (sysdate) next  (sysdate+1/1440)
ENABLE QUERY REWRITE 
AS
SELECT O.ID DIREK_ID,
       MAX(LK.ADI) ISLETME_GERILIMI
  FROM  xxx O, yyy AA,
SYS_LOOKUP LK

  WHERE SDO_RELATE(O.GEOLOC, AA.GEOLOC, 'MASK=ANYINTERACT') = 'TRUE'
 AND LK.ID=AA.ISLETME_GERILIMI_ID
 GROUP BY O.ID,LK.ADI;