Search notes:

Oracle hint: REWRITE_OR_ERROR

The rewrite_or_error hint causes the error ORA-30393: a query block in the statement did not rewrite to be thrown if a query fails to rewrite.

The following query cannot be re-written so that ORA-30393 is thrown:

select /*+ rewrite_or_error */ * from user_tables;

See also