ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
firstname.lastname@example.org. Request a Workshop for
your organization today.
Collection of materialized view refresh statistics.
Owned by SYS with no privileges granted
Direct access to this package is prevented by means of an Accessible By clause.
mv_list IN VARCHAR2,
retention_period IN NUMBER);
exec dbms_mview_stats.purge_refresh_stats('MVSERVERS', 30);
ERROR at line 1:
ORA-20000: ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_IREFRESH", line 186
ORA-06512: at "SYS.DBMS_MVIEW_STATS", line 44
ORA-06512: at "SYS.DBMS_MVIEW_STATS", line 60
ORA-06512: at line 1