Oracle Error ORA-30377: table string.MV_CAPABILITIES_TABLE not found

Oracle Error Message

ORA-30377: table string.MV_CAPABILITIES_TABLE not found

Reason for the Error

You have used the DBMS_MVIEW.EXPLAIN_MVIEW() API before you have defined the MV_CAPABILITIES_TABLE.

Solution

Invoke the admin/utlxmv.sql script after connecting to the desired schema.