This discussion is archived
11 Replies Latest reply: Nov 20, 2012 2:34 PM by Jim Smith RSS

Error in DBMS_MVIEW.REFRESH

796248 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points