SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error in DBMS_MVIEW.REFRESH

796248Nov 20 2012 — edited Nov 20 2012

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2012

Added on Nov 20 2012

#sql-developer

11 comments

2,509 views