11 Replies Latest reply: Nov 20, 2012 4:34 PM by Jim Smith RSS

    Error in DBMS_MVIEW.REFRESH

    796248
      Hi All,

      I am trying to refresh a materialized view 'APPS_TEST.LGC_SYSTEM_ITEM_MV'.
      The command I gave is -
      DMBS_MVIEW.REFRESH ('APPS_TEST.LGC_SYSTEM_ITEM_MV','f');

      However I am getting following error -
      ORA-00900:invalid SQL statement

      Can anyone please let me know what is incorrect with this?
      I am using SQL developer for this.

      Regards,
      Yash