Oracle Error ORA-30380: REWRITE_TABLE does not exist

Oracle Error Message

ORA-30380: REWRITE_TABLE does not exist

Reason for the Error

You have used the DBMS_MVIEW.EXPLAIN_REWRITE() API before you have created the REWRITE_TABLE.

Solution

Create it using the admin/utlxrw.sql script after connecting to the desired schema