REWRITE_TABLE is being created in database when doing an optimization
説明
Toad creates a table “REWRITE_TABLE” table in the login’s schema when doing query tuning. Why is this table being created? Is there a way to have it created in a different schema?
原因
The REWRITE_TABLE is created by Oracle, when DBMS_MVIEW.EXPLAIN_REWRITE is run, which our SQL Tuning functionality uses. The table is created in the current schema when Oracle's utlxrw.sql script is run.
対策
Since this is an Oracle object, and not a Toad object, contact Oracle for questions regarding REWRITE_TABLE.