Oracle Error Message
ORA-30379: query txt not specified
Reason for the Error
You have attempted use DBMS_MVIEW.EXPLAIN_REWRITE() API using an empty query text argument
Solution
Input a valid SQL query
ORA-30379: query txt not specified
You have attempted use DBMS_MVIEW.EXPLAIN_REWRITE() API using an empty query text argument
Input a valid SQL query